展开全部
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;
查询结果:e68a84e8a2ad62616964757a686964616f31333366306465