Return Row With Most Recent Timestamp in a Group by Device

[WebsterTrivium]

I'm trying to build a query to return the row with the most recent timestamp for each device in a table. Currently I have this:

SELECT (Fields)
FROM (Database)
WHERE (Conditions)
GROUP BY deviceID 
HAVING MAX(timestamp);

Which simply returns the first row for each device (Or at least, that's what it looks like). The timestamp is simply an int with the Unix Epoch timestamp. deviceID is a string that stores the name of each device.


Any help is greatly appreciated!

 

[r937]

select [i]columns /* not fields */ [/i]
  from [i]daTable /* not database */[/i] as T
 where [i]conditions[/i]
   and timestampcol =
       ( select max(timestampcol)
           from daTable
          where deviceid = T.deviceid )

r937.com | rudy.ca