Select

SELECT

Select clauses:

• [SELECT](Select Select)
• TOP / LIMIT FETCH
• DISTINCT
• INTO
• FROM
• JOIN ON / USING
• [GROUP BY](Group By)
• HAVING
• WHERE
• [ORDER BY](Order By)
• UNION / [UNION ALL](Union All) /INTERSECT / EXCEPT

Value modifiers

• VALUE, COLUMN, ROW, MATRIX, INDEX, TEXT …

Columns

• City.Name, City.*, Population AS p

Operators

• w*h+20

Aggregators

• SUM(), COUNT(),..

Function

• LCASE(), LEN(), ..