Question

查询Score表中的最高分的学生学号和课程号。

SCORE 表里有 学号，课程号，成绩三项
我写的是 SELECT SNO,CNO FROM SCORE HAVING MAX(DEGREE)
但是提示说：试图执行的查询中不包含作为合计函数一部分的特定表达式'SNO'

Answer 1

Select max(课程号) from score

Answer 2

select top 1 sno,cno form scores order by degree desc

Answer 3

SELECT * FROM SCORE WHERE DEGREE= (SELECT MAX(DEGREE) FROM SCORE)

Answer 4

select sno,sco from score where max(score)