SELECT
c.*
FROM
(
SELECT
@rowNum := @rowNum + 1 AS 'rank',
a.*
FROM
a,
( SELECT @rowNum := 0 ) b
ORDER BY
a.aa DESC
) c
WHERE
c.rank =2
mysql 加一个排序,显示出来具体1,2,3,......排序
最新推荐文章于 2023-03-08 11:54:28 发布
SELECT
c.*
FROM
(
SELECT
@rowNum := @rowNum + 1 AS 'rank',
a.*
FROM
a,
( SELECT @rowNum := 0 ) b
ORDER BY
a.aa DESC
) c
WHERE
c.rank =2