php - 按最大日期选择 account_id

Question

你好，我有如下表格设计

ID       account_id       score     date------------------------------------------    1       500             4               x2       764             4               x3       500             6               x4       500             7               x5       764             5               x

I'm trying to get all rows with the latest account_id entry

so my code should return

ID       account_id       score     date------------------------------------------    4       500             7               x5       764             5               x

I tried the following code but it seems to return the first entry but with the latest date

SELECT account_id,score, max(date) from table group by account_id

Answer 1

情况 1:如果 id 是自增列或者 max(id) 表示最新行。

select * from
(select * from table_name
order by id desc) temp
group by account_id 

情况 2:如果 date 列决定最新行，则将 order 子句 中的 id 替换为 date 和 组子句.