Hello,

I'm using the following SELECT:

SELECT DISTINCT ticket.status, ticket.number, ticket.datum_status FROM ticket WHERE ticket.status IN(3,4) GROUP BY ticket.number ORDER BY ticket.datum_status DESC LIMIT 5;

I get the following result:

4, 'TRA-03-1050', '2010-01-17 13:21:57'
3, 'TRA19-1010', '2010-01-15 12:22:08'
3, 'TRA19-1000', '2010-01-15 12:16:24'

The row values are correct, except for the datum_status, which returns the oldest date, instead of the newest.

Any ideas on how to retrieve the newest?

Thanks!

ORDER BY ticket.datum_status ASC

Hello,

That will only order by result:

3, 'TRA19-1000', '2010-01-15 12:16:24'
3, 'TRA19-1010', '2010-01-15 12:22:08'
4, 'TRA-03-1050', '2010-01-17 13:21:57'

What I need is to retrieve the last modified value of these rows:

4, 'TRA-03-1050', '2010-01-17 13:21:57'
4, 'TRA-03-1050', '2010-01-17 13:24:08'
4, 'TRA-03-1050', '2010-01-17 13:24:15'
4, 'TRA-03-1050', '2010-01-17 13:25:04'
4, 'TRA-03-1050', '2010-01-17 13:25:20'
4, 'TRA-03-1050', '2010-01-17 13:43:39'

Any ideas?

Thanks

SELECT ticket.number, MAX(ticket.datum_status)
FROM ticket
WHERE ticket.status IN(3,4)
GROUP BY ticket.number
ORDER BY ticket.datum_status DESC
LIMIT 5;

Bingo!

Thanks!