Hi Gurus,

Have a table with following data

Name date
James 5-MAR-02
Janes 6-MAR-02
John 6-MAR-02
John 8-MAR-02

I need a select where I get the latest date for a particular user.

Thanks!