There is likely a blindingly obvious solution to this, I need to do a
group by expression in my query and get the latest row based on a date
field in the same table.  
Is this even possible, and any tips on how to do that?

Example of data and query:

-------
Table: 
=(pseudo table based on origional, trimmed)=
'id', 'bigint(20)', '', 'PRI', '', 'auto_increment'
'date', 'datetime', '', '', '0000-00-00 00:00:00', ''
'serial_number', 'varchar(25)', '', '', '', ''
'pass', 'varchar(6)', '', '', 'false', ''
=
SELECT 
         t.pass, t.id
FROM 
        theTable t group by t.serial_number
-------
I have tried putting a sort into the query like so:
SELECT 
         t.pass, t.id
FROM 
        theTable t 
GROUP BY
        t.serial_number
ORDER BY
        t.date desc 


Which naturally only sorts the resulting rows by date.

Reply via email to