34,590
社区成员
发帖
与我相关
我的任务
分享
select 姓名, sum(grade) sums from tablename group by cno,姓名 having sum(grade) > 300
select b.cno,a.name,b.sums from
(select cno,sum(grade) sums from tablename group by cno having sum(grade) > 300 ) as b,
tablename as a
where a.cno=b.cno