union all 、union

  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='144290566957400'
union all 
  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='144291720760260'
union all 
  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='106797989868'

Order_Nbr          Store_Nbr   Channel    D_Recorddate
144290566957400    4803        .CN        2019-12-01
144290566957400    4803        .CN        2019-12-01
144290566957400    4803        .CN        2019-12-01
144290566957400    4803        .CN        2019-12-01
144291720760260    6675        DEPOT      2019-12-01
144291720760260    6675        DEPOT      2019-12-01
144291720760260    6675        DEPOT      2019-12-01
144291720760260    6675        DEPOT      2019-12-01
106797989868       6668        FBP        2019-12-01
106797989868       6668        FBP        2019-12-01
106797989868       6668        FBP        2019-12-01

 

  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='144290566957400'
union  
  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='144291720760260'
union  
  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='106797989868'

Order_Nbr          Store_Nbr    Channel    D_Recorddate
106797989868       6668         FBP        2019-12-01
144290566957400    4803         .CN        2019-12-01
144291720760260    6675         DEPOT      2019-12-01

 

前面去重(unoin)，后面不去重(union all)

  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='144290566957400'
union  
  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='144291720760260'
union  all
  select Order_Nbr,Store_Nbr,Channel,D_Recorddate 
  from SS.Order_Details
  where Order_Nbr='106797989868'

Order_Nbr          Store_Nbr   Channel    D_Recorddate
144290566957400    4803        .CN        2019-12-01
144291720760260    6675        DEPOT      2019-12-01
106797989868       6668        FBP        2019-12-01
106797989868       6668        FBP        2019-12-01
106797989868       6668        FBP        2019-12-01