SQL: select statement

The query result of a select statement can be inserted into a table with an insert statement.

group by

order by

SQL standard feature E051 (Basic query specification)

Selecting the first row or first n rows only

Views allow to give a select statement a name which allows to reuse the same select statement multiple times.

create table … as select …