Question

SQL语句，max函数查询

在一张表里存放着学生考试成绩,用SQL语句查询到最高分的同学
select max(Score) from StuScore

可是，如果要查询最高分的同时，还要让学生的ID显示出来。sql语句怎么写呢?

Answer 1

select id,Score from StuScore where Score =(select max(Score) from StuScore)

Answer 2

select top 1id,max(score) from StuScore
group by score,id
order by score desc