我有一张 comments 表
comment_id | when_added |
---|---|
10 | 02/23/2022 |
21 | 02/23/2022 |
10 | 02/24/2022 |
我需要获得计数、注释id,以及添加时的最新信息
comment_id | when_added | count |
---|---|---|
10 | 02/24/2022 | 2 |
21 | 02/23/2022 | 1 |
我试过这个问题
SELECT COUNT(*) as count, comment_id, when_added
FROM comment
GROUP BY comment_id, when_added
ORDER BY when_added DESC;
是否有一种只使用注释id进行分组的方法?