现在位置:
首页 ＞ SQL Server ＞ 正文
查询不及格科目大于2学号、学生姓名
select sno,count(0) from student
where score <60
group by sno having count(0)>1
select* from (
select ROW_NUMBER() over( order by score desc) as r , * from student
)t
select * from student where sno in(
select sno from student
where score <60
group by sno,sname having count(0)>1
)
order by sno desc , cno asc
============ 欢迎各位老板打赏~ ===========
与本文相关的文章
