[thelist] SQL Max Query Distinct

LOL I wasn't gonna say anything... ;)

Chris Blessing
webguy at mail.rit.eduhttp://www.330i.net

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