Fetch the row with latest data,when multiple rows exist for same user
506037May 17 2006 — edited May 19 2006Hi ,
Thanks for reading the post.I have table with the follwoing data.
user requestdate createdate
-----------------------------------------------------------------
jake 02/21/2006 15:33:41 02/25/2006 15:33:41
jake 04/20/2006 15:33:41 04/21/2006 15:33:41
jake 04/23/2006 15:33:41 04/24/2006 15:33:41
jill 02/21/2006 15:33:41 02/25/2006 15:33:41
jill 04/20/2006 15:33:41 04/21/2006 15:33:41
The data type of user,reqdate,createdate is varchar2.I want to write a query that
gives me all the users and his latest information.After running the query I am expecting the result
user requestdate createdate
-----------------------------------------------------------------
jake 04/23/2006 15:33:41 04/24/2006 15:33:41
jill 04/20/2006 15:33:41 04/21/2006 15:33:41
I am not able to write the correct query.Need help , Thanks
Pandu