Wouldn't that only return 1 row, where Ankit wants the maximum 'usr_amtdetails' for each 'acctid'? Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Pete Sent: 23 January 2008 11:22 To: php-objects@xxxxxxxxxxxxxxx Subject: Re: Please help with a SQL Query 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 *********************************************************************************** Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient or entity to whom they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Random House Group + 44 (0) 20 7840 8400 http://www.randomhouse.co.uk http://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.uk Generic email address - enquiries@xxxxxxxxxxxxxxxxx Name & Registered Office: THE RANDOM HOUSE GROUP LIMITED 20 VAUXHALL BRIDGE ROAD LONDON SW1V 2SA Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 ***********************************************************************************
