The select-statement is the form of a query that can be specified in a DECLARE CURSOR statement, either directly, or prepared and then referenced. It can also be issued through the use of dynamic SQL statements, causing a result table to be displayed on the user's screen.

The table specified by a select-statement is the result of the fullselect.
Read syntax diagramSkip visual syntax diagramWITH,common-table-expressionfullselectread-only-clauseupdate-clauseoptimize-for-clause isolation-clause concurrent-access-resolution-clause

The authorization for a select-statement is described in the Authorization section in "SQL queries".