select * from
(select * from ks_enterprise where 1=1 and is_deleted=0 and is_high_tech_ent=2
union
select * from ks_enterprise where 1=1 and is_deleted=0 and is_sri_ent=2) m
union 如果有重复数据会自动过滤
select * from (select * from ks_enterprise where 1=1 and is_deleted=0 and is_high_tech_ent=2
union ALL
select * from ks_enterprise where 1=1 and is_deleted=0 and is_sri_ent=2)m
union all 有重复数据不会自动过滤,全拼上去
过滤重复的数据 union 和 union all
最新推荐文章于 2024-05-22 02:08:08 发布