query‑specification
The query‑specification clause has the following syntax:
query‑specification::= SELECT [DISTINCT | ALL] select‑list table‑expression
select‑list::= * | select‑sublist [{, select‑sublist} …]
select‑sublist::= derived‑column | [table‑name | table‑identifier].*
derived‑column::= expression [[AS] column‑alias]]
table‑expression::= FROM table reference list [WHERE search‑condition]
[GROUP BY column‑name‑list [[UNION | INTERSECT | EXCEPT] [ALL]
[CORRESPONDING [BY (column‑name‑list)] query specification]
[HAVING search‑condition]
search‑condition::= (see
search‑condition)
Go up to