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...