用SQL查询2009年考试成绩前5名的同学的学号,课程,及分数。
select top 5 studentid,courseid,grade
from grade
where schoolyear=2009
order by grade desc
2021-11-14
最新推荐文章于 2022-07-01 09:20:08 发布
用SQL查询2009年考试成绩前5名的同学的学号,课程,及分数。
select top 5 studentid,courseid,grade
from grade
where schoolyear=2009
order by grade desc