SELECT
t. NAME,
(
SELECT
tt11.rowno
FROM
(
SELECT
tt1.rowno,
tt1. NAME
FROM
(
SELECT
@rowno :=@rowno + 1 AS rowno,
TestTab.*
FROM
TestTab,
(SELECT @rowno := 0) b
ORDER BY
TestTab.语文 DESC
) tt1
) tt11
WHERE
tt11. NAME = t. NAME
) 语文,
(
SELECT
tt11.rowno
FROM
(
SELECT
tt1.rowno,
tt1. NAME
FROM
(
SELECT
@rowno :=@rowno + 1 AS rowno,
TestTab.*
FROM
TestTab,
(SELECT @rowno := 0) b
ORDER BY
TestTab.数学 DESC
) tt1
) tt11
WHERE
tt11. NAME = t. NAME
) 数学,
(
SELECT
tt11.rowno
FROM
(
SELECT
tt1.rowno,
tt1. NAME
FROM
(
SELECT
@rowno :=@rowno + 1 AS rowno,
TestTab.*
FROM
TestTab,
(SELECT @rowno := 0) b
ORDER BY
TestTab.英语 DESC
) tt1
) tt11
WHERE
tt11. NAME = t. NAME
) 英语
FROM
testtab t;
查询结果:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9dcd100baa1cd11812b829eb412c8fcc2ce2deb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)