SQL$HELP72.HLB  —  SELECT  Singleton Select, Format
  (B)0singleton-select =                                         
                                                             
  SELECT qwqqqqqqqqqqqqqwq> select-list qqk                  
          tq> ALL qqqqqqu                 x                  
          mq> DISTINCT qj                 x                  
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                  
    mq> into-target qqqqqqqqqqqqqqqqqk                       
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                       
    m> FROM qwqq> table-ref qqqqqwqk                         
             mqqqqqqqqqq , <qqqqqj x                         
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                         
    m> WHERE predicate qwqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqwk   
                        mq> GROUP BY qw> <column-name> wjx   
                                      mqqqqqqq , <qqqqqj x   
    lqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqj   
    mwqqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqqwqqqqk   
     m> HAVING predicate qj mq> limit-to-clause qqqqj    x   
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
    mqwqqqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqwqqqqqq>
      m> for-update-clause qj mq> optimize-clause qqj

  (B)0into-target =
  qqqq> INTO qqwqwq> <parameter> qqqqqqqqqqqwwq>
               x tq> <qualified-parameter> qux  
               x mq> <variable> qqqqqqqqqqqqjx  
               mqqqqqqqqqqqqq , <qqqqqqqqqqqqj  
                                                

  (B)0for-update-clause =                           
                                                
  qq> FOR UPDATE qwqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
                  mqwq> OF <column-name> qwqj   
                    mqqqqqqqq , <qqqqqqqqqj     
                                                

  (B)0optimize-clause =                                                 
                                                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq> 
    mq> OPTIMIZE qqwqwq> FOR qwq> FAST FIRST qqqqqqqqwqqqqqqqqqqwqwqj     
                   x x        tq> TOTAL TIME qqqqqqqqu          x x       
                   x x        mq> SEQUENTIAL ACCESS qj          x x
                   x tq> USING <outline-name> qqqqqqqqqqqqqqqqqqu x 
                   x tq> WITH qwq> DEFAULT  qqwq> SELECTIVITY  qu x
                   x x         tq> SAMPLED  qqu                 x x
                   x x         mq> AGGRESSIVE j                 x x
                   x mq> AS <query-name> qqqqqqqqqqqqqqqqqqqqqqqj x 
                   mqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
                                                                    
Close Help