SQL$HELP_OLD72.HLB  —  SELECT  Singleton Select, Format
  singleton-select =

  SELECT -+-------------+-> select-list --+
          +-> ALL ------+                 |
          +-> DISTINCT -+                 |
    +-------------------------------------+
    +-> into-target -----------------+
    +--------------------------------+
    +> FROM -+--> table-ref -----+-+
             +---------- , <-----+ |
    +------------------------------+
    +> WHERE predicate -+------------->-----------------++
                        +-> GROUP BY -+> <column-name> ++|
                                      +------- , <-----+ |
    +--------------------------<-------------------------+
    ++--------------------+-+-----------------------+----+
     +> HAVING predicate -+ +-> limit-to-clause ----+    |
    +----------------------------------------------------+
    +-+---------------------+-+---------------------+------>
      +> for-update-clause -+ +-> optimize-clause --+

  into-target =
  ----> INTO --+-+-> <parameter> -----------++->
               | +-> <qualified-parameter> -+|
               | +-> <variable> ------------+|
               +------------- , <------------+

  for-update-clause =

  --> FOR UPDATE -+-------------------------+->
                  +-+-> OF <column-name> -+-+
                    +-------- , <---------+

  optimize-clause =

  --+---------------------------------------------------------------+--->
    +-> OPTIMIZE --+-+-> FOR -+-> FAST FIRST --------+----------+-+-+
                   | |        +-> TOTAL TIME --------+          | |
                   | |        +-> SEQUENTIAL ACCESS -+          | |
                   | +-> USING <outline-name> ------------------+ |
                   | +-> WITH -+-> DEFAULT  --+-> SELECTIVITY  -+ |
                   | |         +-> SAMPLED  --+                 | |
                   | |         +-> AGGRESSIVE +                 | |
                   | +-> AS <query-name> -----------------------+ |
                   +---------------- <----------------------------+
Close Help