How can I fetch distinct records from a query?

sreray
sreray ✭
in Asset Management
Does J1QL support the use of DISTINCT keyword (or something similar) to fetch distinct records? 

Best Answer

  • AaronO
    AaronO ✭✭✭
    Answer ✓
    J1Ql doesn't support the keyword DISTINCT, but aliasing the return statement can typically categorize results in the same way.  In this case find Unique aws_instance as ec2 return ec2.region, COUNT(ec2) should suite your need!

This Month's Leaders

Categories