6.6 Aggregation and Sorting with PGQL

Like SQL, PGQL has support for the following:

• GROUP BY to create groups of solutions

• MIN, MAX, SUM, and AVG aggregations

• ORDER BY to sort results

And for many other familiar SQL constructs.

See Also:

• See Grouping and Aggregation for more information on GROUP BY
• See Sorting and Row Limiting for more information on ORDER BY