MySQL-字段间的结果怎么显示名次

Question

表：
name class A B C D E
张三 五年级 98 88 92 90 88

像这种 A、B、C、D、E 五个是课程，怎么让张三这个人的课程加上排名。
比如 A 第一， C第二， D第三 B第四 E第五

Answer 1

SET @num=0,@num1=0;
SELECT num.id, num.rank AS rank,numm.rank AS rank1, num.num AS num,numm.num1 AS num1, num.named FROM (SELECT id, @num:=@num+1 AS rank,num,named FROM a ORDER BY num DESC)AS num INNER JOIN (SELECT id, @num1:=@num1+1 AS rank,num1 FROM a ORDER BY num1 DESC)AS numm ON num.id=numm.id

这个是写成一条的样子
SELECT num.id, num.rank AS rank,numm.rank AS rank1, num.num AS num,numm.num1 AS num1, num.named FROM

(SELECT aa.id, @num:=@num+1 AS rank,aa.num,aa.named FROM (SELECT * FROM a ORDER BY num DESC) AS aa,(SELECT @num:=0) s)AS num
INNER JOIN
(SELECT aaa.id, @num1:=@num1+1 AS rank,aaa.num1 FROM (SELECT * FROM a ORDER BY num1 DESC) AS aaa,(SELECT @num1:=0) ss)AS numm
ON
num.id=numm.id

目前是两科 剩下的你就继续往下拼就行了