I have table which holds the data like below
A 29/08/2013 12:52:42 AM
B 11/05/2012 03:29:44 AM
C 22/08/2013 01:31:19 AM
D 21/07/2013 03:29:44 AM
I can fetch the latest data based on the date from above result set. But now i need to fetch the data of second date in the list. I mean the previous date of the latest one.