The syntax for SELECT in BNF is as follows:

Syntax

select statement ::=
query_expression  ORDER BY {expr|posn}[ ASC | DESC ]
   [ , {expr|posn}[ ASC | DESC ] , ...] 
 FOR UPDATE [ OF [table.]column_name , ...] ;

For more information, see SELECT.