A newer version of this documentation is available.

View Latest

SELECT/subselect statement

SELECT statements can begin with either SELECT or FROM. The behavior is the same in either case.

subselect:

select-from | from-select

select-from:

select-clause [from-clause] [let-clause] [where-clause]  [group-by-clause]

from-select:

from-clause [let-clause] [where-clause] [group-by-clause] select-clause