unique record based on date query

[mark]

i have a query that does this :-

userid nextactiondate
1 26/02/2004
1 27/03/2004
1 04/03/2004
1 01/01/1900

i want the query to just show a single userid with the highest
nextactiondate eg it should just show
1 27/03/2004

cheers

mark

 

[KP]

try using

select userid , max(nextactiondate) as Date
from tablename
group by userid

 

[mark]

thanks worked a treat!
mark

try using

select userid , max(nextactiondate) as Date
from tablename
group by userid