I nedd query for slecting only recent date details.......
hi...
i hav table ABC
with A B C as column
A B C
1 AA 1/1/2009
2 BB 1/2/2009
3 BB 1/3/2009
4 aa 1/2/2009
i need a select query with follwng result.
4 aa 1/2/2009
3 BB 1/3/2009
thse two row only ,ie recent date detail (only) of each entries....
help me pls...
Rajeswari nathanPosted Oct 9, 2009, 6:50 AM
Select top 2 * from ABC order by date desc...