[thelist] SQL Max Query Distinct

[Chris Blessing]

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

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

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