Select max(课程号) from score
select top 1 sno,cno form scores order by degree desc
SELECT * FROM SCORE WHERE DEGREE= (SELECT MAX(DEGREE) FROM SCORE)
select sno,sco from score where max(score)
