Hi Friends, I've been looking for an answer to this problem for quite sometime but an unable to find one. I hope someone from group can help me guide to the right way. Here's my SQL Query: SELECT AmtAfter, AcctID FROM Usr_AmtDetails Order By AcctRecharged Data Retrieved by the Query: AmtAfter AcctId 2006.12 0002801964006.12 0002801960.00 0021018391000.55 0021075181001.24 0021075181012.92 0021075181242.25 002107518996.53 002107518999.49 0021075181590.02 002107582 Data I want: AmtAfter AcctId 2006.12 0002801960.00 0021018391000.55 0021075181590.02 002107582 Basically, I want only the latest entry of an distinct accountids & not the rest of the records also. Can someone guide me to a solution. Thanks Ankit Mathur _________________________________________________________________ Post free property ads on Yello Classifieds now! www.yello.in http://ss1.richmedia.in/recurl.asp?pid=219 [Non-text portions of this message have been removed]
