mysql成绩排名，如何写sql语句

你参考一下下面的代码，可不可行

USE test; 
DROP TABLE IF EXISTS `stu_mark`; 
CREATE TABLE `stu_mark` ( 
  `id` INT(10) NOT NULL AUTO_INCREMENT, 
  `name` VARCHAR(20) NOT NULL, 
  `mark` INT(11) NOT NULL, 
  PRIMARY KEY (`id`) 
) ENGINE=INNODB DEFAULT CHARSET=utf8; 
INSERT INTO stu_mark(`name`, `mark`) 
VALUES ('lisi',10),('zhangsan',20),('wangwu',20),('zhaoliu',30),('liuqi',50),('anjiu',100); 
SELECT `name`, `mark`,sor FROM( 
    SELECT `name`, `mark` 
       ,(CASE WHEN @tMark=mark THEN @tm ELSE @tm :=@tm+1 END) AS sor 
       ,(@tMark:=mark) AS tm 
    FROM  `stu_mark` AS m ,(SELECT @tm :=0,@tMark:=0) AS t1
   ORDER BY mark DESC
) AS t2 
ORDER BY t2.sor desc