Have you tried this: select ..., max(date) as mdate from ... where ... group by ... order by mdate desc ?
I haven't tested it, but it should order the results by max date descending, giving you the greatest date first. On Fri, 10 Sep 2004 18:16:00 -0700, bruce <[EMAIL PROTECTED]> wrote: > hi... > > i have the following select... > select > itemID, > process, > status, > tblType, > max(date) > from historyTBL > where (tblType = '3' or tblType = '2') > group by tblType; > > it seems to work, in that it gives me the rows for the two types that i'm > grouping by. > > the problem is that i want the row that contains the max date. the query is > only returning the max date, with the other elements in the row coming from > who knows where in the table. > > any idea on how i can achieve the complete row containing the max date??? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
