sql合并

cy1210 发布于 2016-04-26 21:03， 2757 次点击

如何将下列两个sql 合成一个简单的sql？？？

SELECT DPItemId,COUNT(1) idcount
FROM  T
where     DPDate<='2016-04-15'
group by DPItemId
having count(1) <=10
) as t

select count(*)  from (SELECT DPItemId,COUNT(1) idcount
FROM T2
where  DPDate<='2016-04-15'
group by DPItemId
having count(1) >10
and count(1) <=50
) as t

1 回复

dairui2016-05-01 23:06

SELECT DPItemId,sum(idcount) idcount,sum(idcount2) idcount2
from (
SELECT DPItemId,COUNT(1) idcount,0 idcount2
FROM  T
where     DPDate<='2016-04-15'
group by DPItemId
having count(1) <=10
union all
SELECT DPItemId,0 idcount,COUNT(1) idcount2
FROM T2
where  DPDate<='2016-04-15'
group by DPItemId
having count(1) >10
and count(1) <=50
) a
group by DPItemId