W3cubDocs

/SQLite

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

SQLite is in the Public Domain.
https://sqlite.org/syntax/select-core.html