Solution Modifiers

The optional query modifiers enable you to restrict, group, sort, or further refine results:

• ORDER BY: This modifier sorts the result set in a particular order. It sorts query solutions on the value of one or more variables.
• OFFSET: Using this modifier in conjunction with LIMIT and ORDER BY returns a slice of a sorted solution set, for example, for paging.
• LIMIT: This modifier restricts the results to return a certain number of solutions.
• GROUP BY: This modifier is used with aggregate functions and specifies the key variables to use to partition the solutions into groups. For information about AnzoGraph GROUP BY clause extensions, see Advanced Grouping Sets.
• HAVING: This modifier is used with aggregate functions and further filters the results after applying the aggregates.