按某一字段排序生成名次

  
    
  select   rank=count(*),   a1.studentname,   a1.score  
        from   student   a1,   student   a2  
        where   a1.score   >=   a2.score  
        group   by   a1.studentname,   a1.score  
        order   by   a1.score