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

浙公网安备 33010602011771号