日期:2014-05-19  浏览次数:20437 次

提问一个sql语句,帮我看看!
select   uid,sum(shu1)   as   shu1he,sum(shu2)   as   shu2he,shu1+shu2   as   zonghe
from   shuzi
group   by   uid

中,如果要将zonghe小于1000的不显示出来,应该怎么加呢?

------解决方案--------------------
select uid,sum(shu1) as shu1he,sum(shu2) as shu2he,sum(shu1+shu2) as zonghe
from shuzi
group by uid
group by uid having sum(shu1+shu2)> =1000
------解决方案--------------------
select uid,
sum(shu1) as shu1he,
sum(shu2) as shu2he,
sum(shu1+shu2) as zonghe
from shuzi
group by uid
having sum(shu1+shu2)> =1000
------解决方案--------------------
select * from (select uid,sum(shu1) as shu1he,sum(shu2) as shu2he,shu1+shu2 as zonghe
from shuzi
group by uid) as a where a.zonghe> =1000