要查询成绩排前5名的学生，SQL语句该怎样写？

[TsungLee]

请教。

[txlicenhe]

1:
Select top 5 * from 表 order by 成绩 desc
2:
Select top 5 姓名,sum(总成绩）from 表 group by 姓名 order by sum(总成绩) desc

[Tjackyren]

select top 5 * from 表名 where 条件 order by 成绩 asc

[jinewei]

select top 5 * from 表名 order by 成绩字段 desc

[chpp_2000]

select top 5 姓名，成绩 from table_name where 条件 order by 成绩

[LengyuYuan]

select top 5 * from GradeTable order by Grace Desc

[chpp_2000]

select top 5 姓名，成绩 from table_name where 条件 order by 成绩 desc

[伍子V5]

select top 5 * from 表名 where 条件 order by 成绩 asc