MySQL; How to GROUP BY an select newest?

Asked May 08 '17 at 12:55

Active May 08 '17 at 12:55

Viewed 26 times

Let's say I have the following table in MySQL.

I have the following query: SELECT * FROM my_table GROUP BY names.

This will make a list where every name will only appear once but it doesn't take care of the year. I need to SELECT always the latest entry. Means e.g. Peter | 2016 for Peter.

How can I do this?

edited Jun 20 '20 at 09:12

Community

asked May 08 '17 at 12:55

Try using order by too. – Jyoti mishra May 08 '17 at 13:04
This will only order the result after selected. Any other idea? – May 08 '17 at 13:11
ur question ia marked as duplicate. you can check the same question asked before and get ideas. if don't get let me know. – Jyoti mishra May 08 '17 at 13:19
@Jyotimishra Unfortunately this solution doesn't work for me. – May 08 '17 at 13:21
SELECT * FROM `user` WHERE 1 GROUP BY names ORDER BY year DESC LIMIT 0 , 30 – Jyoti mishra May 08 '17 at 13:26
@Jyotimishra Doesn't work, still the same. – May 08 '17 at 13:27
I finally found the solution: `SELECT * FROM (SELECT * FROM my_table ORDER BY year DESC) x GROUP BY names;` – May 09 '17 at 07:26

MySQL; How to GROUP BY an select newest?

0 Answers0