select * from tb order by cast(成绩 as int) descselect avg(成绩) from tb前提是你的成绩字段里只能是数字,不能包含其他的字母和特殊字符
select 成绩 , cast(成绩 as decimal(18,2)) from tb order by cast(成绩 as decimal(18,2)) descselect 学生ID , avg(cast(成绩 as decimal(18,2))) from tb group by 学生ID order by avg(cast(成绩 as decimal(18,2))) desc
select 成绩 , cast(成绩 as decimal(18,2)) from tb order by cast(成绩 as decimal(18,2)) descselect 学生ID , avg(cast(成绩 as decimal(18,2))) from tb group by 学生ID order by avg(cast(成绩 as decimal(18,2))) desc