首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

提问一个sql语句,帮小弟我看看

2012-01-19 
提问一个sql语句,帮我看看!selectuid,sum(shu1)asshu1he,sum(shu2)asshu2he,shu1+shu2aszonghefromshuzigr

提问一个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
[解决办法]
selectuid,
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

热点排行