In message <BAY124-W6BDDA9737EFF1293CB644AB3F0@xxxxxxx>, Ankit Mathur <ankitmathur82@xxxxxxxxxxx> writes >Here's >my SQL Query:SELECT AmtAfter, AcctID FROM Usr_AmtDetailsOrder By AcctRecharged >Data Retrieved by the Query:AmtAfter AcctId >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 SELECT AmtAfter, AcctID FROM Usr_AmtDetails Order By AcctRecharged DESC LIMIT 1; -- Pete Clark Sunny Andalucia http://hotcosta.com/Andalucia.Spain
