[thelist] SQL Max Query Distinct

[rudy]

select id, max([pleasetellmeyoudidn'tnameyourdatefield"Date"])
  from yourtable
group by id

;o)


rudy