如何从两个不同的行中获取两个最大id?

一种方法使用子查询的联接来限制您所需的最大行数:

SELECT ca1.id, ca1.request_id, ca1.approver_id
FROM customer_approved ca1
INNER JOIN
(
    SELECT approver_id, MAX(id) AS max_id
    FROM customer_approved
    GROUP BY approver_id
) ca2
    ON ca1.approver_id = ca2.approver_id AND
       ca1.id = ca2.max_id;

Demo

如果您使用的是MySQL 8+,那么您还可以使用 ROW_NUMBER 在这里:

WITH cte AS (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY approver_id ORDER BY id DESC) rn
    FROM customer_approved
)

SELECT id, request_id, approver_id
FROM cte
WHERE rn = 1;

Demo

您可以对列应用GROUP BY request\u id&approver\u id,然后选择MAX(id)以获得预期的输出,如下所示-

SELECT MAX(id),request_id ,approver_id
FROM customer_approved
GROUP BY request_id,approver_id