Small. Fast. Reliable.
Choose any three.

select-core

SELECT DISTINCT result-column , ALL FROM table-or-subquery , 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   result-column   table-or-subquery

See also:   lang_select.html