给一个数据库表，ID、score两个字段分别代表学生ID和成绩，写SQL语句求ID=？的学生排第几名？

CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `score` double NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

有如下信息

求输出学生id，成绩，以及排名

SELECT id,score,(SELECT COUNT(*)+1 FROM student WHERE a.score<score) AS sort FROM student a ORDER BY sort

直接输出学生id=？的排名

SELECT (SELECT COUNT(*)+1 FROM student WHERE a.score<score) AS sort FROM student a where id=? ORDER BY sort