sql 语句集合

UNION ALL 并列写

select count(*) from base1
union all
select count(*) from base2
union all
select count(*) from base3

inner join 内连接

select neu.id,count(*) from cm_cni_bandwidth_op op
inner join cm_cni_qos_policies_neu neu on neu.id = op.id 
where op.IS_DELETE = 0;
posted @ 2025-03-06 15:57  布丁家的苏苏  Views(3)  Comments(0)    收藏  举报