mysql select latest entry by time
I have the following table:
ID NAME TIME
1 A 0
2 A 3
3 B 1
I am using the query below which produces:
SELECT * FROM `table` GROUP BY `NAME`
ID NAME TIME
1 A 0
3 B 1
And I want use GROUP BY to generate a result like this (discount sort by the TIME column):
ID NAME TIME
2 A 3
3 B 1
SELECT NAME, MAX(TIME) as TIME
FROM table
GROUP BY time
ORDER BY time DESC