mysql - 选择表中每个最大值的id

Question

如何选择表中每个最大值的 id？

预期输出:

Answer 1

你可以这样做:

SELECT * FROM(
    SELECT distinct id as 1st
    FROM YourTable
    WHERE 1st =(select max(1st)
                FROM YourTable))
INNER JOIN
    (SELECT distinct id as 2nd
    FROM YourTable
    WHERE 2nd =(select max(2nd)
                FROM YourTable))
ON(1=1)  

这仅在每列中有 1 个最大值的情况下才有效。

下次您提出问题时，请自己尝试解决它。​​