mysql行号order by_mysql – 从每个GROUP BY(unique_id)和ORDER BY号中选择具有MAX id的行

您可以将查询用作子查询：

SELECT *

FROM table

WHERE id IN (SELECT MAX(id) AS id

FROM table

WHERE final=0 AND username='$username' AND active=1

GROUP BY unique_id)

ORDER BY order_number

或者,如果id不唯一,请使用JOIN：

SELECT t1.*

FROM table AS t1

JOIN (SELECT MAX(id) AS max_id, unique_id

FROM table

WHERE final=0 AND username='$username' AND active=1

GROUP BY unique_id

) AS t2 ON t1.unique_id = t2.unique_id AND t1.id = t2.unique_id

ORDER BY order_number