Dear Pals,
Actually I have a table named as "Advance"
It contains 4 fields,
1. Emp_Name
2. Date_of_Advance
3. Advance
4. Tot_Advance.
I have enter three various values for each employee to that table....like
Katheeja - 19/02/2010 - 2000 - 2000
Katheeja - 24/11/2011 - 2500 - 4500
Katheeja - 01/03/2012 - 1000 - 5500
Guna - 20/02/2010 - 1000 - 1000
Guna - 25/11/2011 - 2500 - 3500
Guna - 05/03/2012 - 3000 - 6500
Actually I need to fetch last row from above.
To katheeja:
Katheeja - 01/03/2012 - 1000 - 5500
To Guna:
Guna - 05/03/2012 - 3000 - 6500
I need query for that.
Thanks in advance.
- Gunapriyan