提问一个sql语句,帮我看看! select uid,sum(shu1) as shu1he,sum(shu2) as shu2he,shu1+shu2 as zonghefrom shuzigroup by uid中,如果要将zonghe小于1000的不显示出来,应该怎么加呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select uid,sum(shu1) as shu1he,sum(shu2) as shu2he,sum(shu1+shu2) as zonghefrom shuzigroup by uidgroup by uid having sum(shu1+shu2)>=1000 select uid, sum(shu1) as shu1he, sum(shu2) as shu2he, sum(shu1+shu2) as zonghefrom shuzigroup by uidhaving sum(shu1+shu2)>=1000 select * from (select uid,sum(shu1) as shu1he,sum(shu2) as shu2he,shu1+shu2 as zonghefrom shuzigroup by uid) as a where a.zonghe>=1000 怎么把ppt文件存入数据库中 SQL求高手求优化 Delphi ListView排序 求一个简单的查询 关于SQL的拼接,单引号问题~~在线等~~着急~~ sql实现学生总分名次的排序 一个 获得不重复 行的 问题 ? 求救!关于MSSQL Server的出错信息 查询时能否得到每一行的行号(标识第几行)? 建SQL数据表的问题... SQL 递归查询请教 ■■■各位高手这个用游标的触发器这样写有没有必要
from shuzi
group by uid
group by uid having sum(shu1+shu2)>=1000
sum(shu1) as shu1he,
sum(shu2) as shu2he,
sum(shu1+shu2) as zonghe
from shuzi
group by uid
having sum(shu1+shu2)>=1000
from shuzi
group by uid) as a where a.zonghe>=1000