Select

SELECT

Select clauses:

• WITH
• [SELECT columns](Select Columns)
• [REMOVE COLUMNS](Remove Columns) columns / LIKE pattern
• TOP / LIMIT FETCH
• DISTINCT
• INTO
• FROM
• JOIN ON / USING
• APPLY
• LET
• [GROUP BY](Group By)
• HAVING
• WHERE
• [ORDER BY](Order By)
• UNION / [UNION ALL](Union All) /INTERSECT / EXCEPT / CORRESPONDING

Return value modifiers

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

[Columns](Select Columns)

    SELECT City.Name, City.*, Population AS p FROM Cities

Select [_](Underscore Object) - underscore object - whole row

Operators

    SELECT w*h+20 FROM ?

Aggregators

   SELECT SUM(x), COUNT(*) FROM arr

Functions

    SELECT LCASE(name), LEN(name) FROM names

See also: SEARCH