下面是求解该问题的 MySQL 代码:
SELECT a, (
SELECT b
FROM table_name
WHERE a = t1.a
ORDER BY b DESC
LIMIT 1
) - (
SELECT b
FROM table_name
WHERE a = t1.a
ORDER BY b DESC
LIMIT 1, 1
) AS result
FROM table_name t1
GROUP BY a;
在代码中,table_name
表示你想要操作的表的名称,a
和 `