I have a comment form
| comment_id | when_added |
|---|---|
| 10 | February 23, 2022 |
| twenty one | February 23, 2022 |
| 10 | February 24, 2022 |
I need to get the count, comment_id and the latest when_added
| comment_id | when_added | count |
|---|---|---|
| 10 | February 24, 2022 | 2 |
| twenty one | February 23, 2022 | 1 |
I tried this query
SELECT COUNT(*) as count, comment_id, when_added FROM comment GROUP BY comment_id, when_added ORDER BY when_added DESC;
Is there a way to group by just using comment_id?
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
You should only group by
comment_idand use theMAX()aggregate function to get the lastwhen_addedof eachcomment_id：SELECT comment_id, MAX(when_added) last_when_added, COUNT(*) count FROM comment GROUP BY comment_id ORDER BY last_when_added DESC;