select name, max(date) from table_name
group by name;

SQL> select * from supp2;

NAME DATE_IN
---------- ---------
John 16-SEP-02
John 13-SEP-02
James 15-SEP-02
James 14-SEP-02
James 13-SEP-02

SQL> select name, max(date_in)
2 from supp2
3 group by name;

NAME MAX(DATE_
---------- ---------
James 15-SEP-02
John 16-SEP-02