Question

MySQL问题（语法）

有四张表:
student(SNO,SSEX,SBIRTHDAY,CLASS)
course(CNO,CNAME,TNO)
score(SNO,CNO,DEGREE)
teacher(TNO,TNAME,TSEX,TBIRTHDAY,PORF,DEPART)
现在要查询score表中最高分的学生学号和课程号
我写的是select sno,cno from score where degree=max(degree);
但是有语法错误，到底错哪里了？

Answer 1

select sno,cno from score where degree=(select max(degree) degree from score);

或者select sno,cno, max(degree) degree from score