大神快来啊

[qq_21836647]

sql 有几个同学当他们的语文,数学成绩一样时按照某个同学的英语成绩判断谁是第一名?
(表student 语文(china)数学(math)英语(eglish))

[Ekun_sky]

select top 1 * from 成绩 order by student+china+eglish desc

[qq_21836647]

很感谢楼上的回复，但是你那样写有问题和我的问题不是一样 我的问题现在已经出来了。 select top 1 from student b1 where english =(select max(english) from student b2 where b1.china=b2.china and b1.math=b2.math ) order by english

[spiritofdragon]

你的需求很不明确，我理解，是不是排序，先按 数学+语文，再按英语？

with student(student,china,math,english) as 
(
select 'a',80,81,83 union all
select 'b',80,81,79 union all
select 'c',90,91,78 union all
select 'd',90,91,92 
)
select * from student
order by china+math desc ,english desc