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_AmtDetailsOrder By AcctRecharged Please see the attached picture for results of the Query & Results I want. 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.ThanksAnkit 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]
