Technology Editor:SQL

The SQL properties are reserved for technologies with data or join filtering capacities (using the WHERE clause). 

Where

This section details the syntax used for filter clauses. It is only displayed for technologies with a data array filtering capacity.

Order by 

Shows the type of syntax used in SQL for the technology, following an ORDER BY clause. The possible values are:

Complex Expression: The clause is followed by a complex expression or the column name.

Column Number: The ORDER BY clause is followed by the column numbers.

Alias: The ORDER BY clause is followed by the column aliases. 

Group by Shows the type of syntax used in SQL for the technology, following a GROUP BY clause. The possible values are the same as for an ORDER BY clause.

Having Shows the type of syntax used in SQL for the technology, following a HAVING clause. The possible values are the same as for an ORDER BY clause.