Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram                        .-,--------.
                        V          |
>>-select-clause--INTO----variable-+---------------------------->
 
>--from-clause--+--------------+--+-----------------+--+---------------+-->
                '-where-clause-'  '-group-by-clause-'  '-having-clause-'
 
                                               (1)
>--+-----------------+--+--------------------+-------+------------------+-><
   '-order-by-clause-'  '-fetch-first-clause-'       '-isolation-clause-'
 
Notes:
  1. Only one row may be specified in the fetch-first-clause.