order by 分数,姓名

  
select * from 数据表 order by 班级,分数,姓名

create table tb 
( 
姓名 varchar(10), 
班级 int, 
分数 int, 
名次 int 
) 
insert into tb 
select 
'zhaoying'  , 1,60,0 union select 
'douye'      , 1,58,0 union select 
'machao'    , 1,58,0 union select 
'liujie'    , 1,54,0 union select 
'zhangqiang' , 2,54,0 union select 
'machuang'  , 2,66,0 

update T set 名次=(select count(1) from tb where 班级 = T.班级 and 分数>T.分数)+1 from tb T 

select * from tb order by 班级,名次

/*
姓名             班级   分数    名次
zhaoying     1    60    1
douye            1    58    2
machao            1    58    2
liujie            1    54    4
machuang    2    66    1
zhangqiang    2    54    2

*/

drop table tb

create table t1 (sname varchar(10),classid int,score int)
insert into t1 
select 'zhaoying',1,60
union all
select 'douye',1,58
union all
select 'machao',1,58
union all
select 'liujie',1,54
union all
select 'zhangqiang',2,54
union all
select 'machuang',2,66


select *,
    (
    select count(*)  from t1 where classid=a.classid
         and (score>a.score or (score=a.score and sname>a.sname))
    )+1 as rank
from t1 a
order by classid ,rank