SELECT statement options

The options on the SELECT statement must be in the order shown in the following syntax diagram:

SELECT statement block

SELECT option block

See SELECT.

INTO option block

See INTO.

FROM option block

See FROM.

WHERE condition

See WHERE-condition.

ORDER BY option block

See ORDER-BY.

OPTIONS option block

See OPTIONS.

ESTROWS integer

See ESTROWS.

; (semicolon) block

See semicolon.