CODE EXAMPLE FOR SQL

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