[thelist] SQL Max Query Distinct

[rudy]

and if you want the other columns from the row which has the latest date,

select id, foo, bar, thedate
  from yourtable XX
inner
  join ( select id
              , max(thedate) as maxdate
           from yourtable
       group by id ) YY
    on XX.id= YY.id
   and XX.thedate = YY.maxdate


rudy