MySQL order by

Status
Not open for further replies.
C

clau

Hi all, I have a table that contains duplicate data.

I am trying to pull all of the most recent rows from the table

SELECT * FROM 'data' ORDER BY 'timestamp' GROUP BY 'name'

This query produces SQL erros. How can I pull out the "latest version" of all the names in the table?
 
Status
Not open for further replies.
Top