Table Functions

Reference for AQL's four table functions (select, group, filter, and unique), each of which transforms an input table expression into an output table result.

Table functions transform an input table expression into an output table result.

Function	Syntax	Purpose
select	`select(table, field1, field2, [,...])`	Selects the fields to be returned in the query result.
group	`group(table, field1, field2, [,...])`	Groups the result set by the specified field(s).
filter	`filter(table, condition1, condition2, [,...])`	Filters the result set to include only rows that satisfy the specified conditions
unique	`unique(table, field1, field2, [,...])`	Returns the unique values of the specified field(s).