mysql查询倒数第二条数据

SELECT MAX(id) FROM table_name;

SELECT * FROM table_name WHERE id = (SELECT MAX(id) - 1 FROM table_name);

+----+--------+----------+
| id |  name  |  value   |
+----+--------+----------+
|  3 | Alice  |   100    |
+----+--------+----------+

SELECT * FROM table_name ORDER BY id DESC LIMIT 1, 1;

+----+--------+----------+
| id |  name  |  value   |
+----+--------+----------+
|  3 | Alice  |   100    |
+----+--------+----------+

WITH numbered_table AS (
    SELECT *, ROW_NUMBER() OVER (ORDER BY id DESC) AS rn
    FROM table_name
)
SELECT * FROM numbered_table
WHERE rn = 2;

+----+--------+----------+----+
| id |  name  |  value   | rn |
+----+--------+----------+----+
|  3 | Alice  |   100    |  2 |
+----+--------+----------+----+