unionall.txt

SQL语句集锦,很多精彩的语句,希望深入SQL的朋友可以研究一下.

  select   *   from   A   
  union     
  select   *   from   B   
    
    
    
  --不合并重复行   
  select   *   from   A   
  union   all   
  select   *   from   B   
    
    
  --如果要对字段进行排序   
  select   *   
  from   (   
  select   id,...   from   A   
  union   all   
  select   id,...   from   B   
  )   t   
  order   by   ID