select class from 表 where sex='男' group by class having(sum(score))>150 order by sum(score) desc
create table tb(no int,score int,sex char(2),class int) insert into tb values(1,100,'男',1) insert into tb values(2,50 ,'男',1) insert into tb values(3,56 ,'女',1) insert into tb values(4,90 ,'男',2) insert into tb values(5,61 ,'男',2) insert into tb values(6,70 ,'男',3) insert into tb values(7,97 ,'男',3) goselect class,sum(score) score from tb where sex = '男' group by class having sum(score) > 150 order by score descdrop table tb/* class score ----------- ----------- 3 167 2 151(所影响的行数为 2 行) */
insert into tb values(1,100,'男',1)
insert into tb values(2,50 ,'男',1)
insert into tb values(3,56 ,'女',1)
insert into tb values(4,90 ,'男',2)
insert into tb values(5,61 ,'男',2)
insert into tb values(6,70 ,'男',3)
insert into tb values(7,97 ,'男',3)
goselect class,sum(score) score from tb where sex = '男'
group by class having sum(score) > 150
order by score descdrop table tb/*
class score
----------- -----------
3 167
2 151(所影响的行数为 2 行)
*/