select * from a union select * from b 能详细说下么

来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 16:39:38
select * from a union select * from b 能详细说下么
x)+NIM.QRH+UHT(S@MRxѼewXɎ';;l׬_`gCWy)>_rQx6c]K^n ?ݹ x>igf]g>_ 4Ov9'?7h:O't-J<۴ٜΗOX~l

select * from a union select * from b 能详细说下么
select * from a union select * from b 能详细说下么

select * from a union select * from b 能详细说下么
恩,UNION 跟 UNION ALL 是交集跟并集的写法
select * from a union select * from b --这种是A表与B表结果的交集写法,合并表,没有重复行;
select * from a union all select * from b --这种是A表与B表结果的并集写法 有重复行;