Small. Fast. Reliable.
Choose any three.

select-core

SELECT DISTINCT result-column , ALL FROM table-or-subquery join-clause , WHERE expr GROUP BY expr HAVING expr , WINDOW window-name AS window-defn , VALUES ( expr ) , ,

Used by:   compound-select-stmt   factored-select-stmt   simple-select-stmt

References:   expr   join-clause   result-column   table-or-subquery   window-defn

See also:   lang_select.html