In message <C2C319C4C1CC7D46B2D7815BE3A2753E03CEC681@coxsrv- 3.uk.randomhouse.com>, Atkinson, Robert <ratkinson@xxxxxxxxxxxxx> writes >Wouldn't that only return 1 row, where Ankit wants the maximum >'usr_amtdetails' for each 'acctid'? > >Rob. Yes, it would only return 1 row, - that's what I understood that he wanted. He said >>Basically, I want only the latest entry of an distinct accountids and didn't mention maximum anywhere. Perhaps I am misunderstanding what he wants. -- Pete Clark Sunny Andalucia http://hotcosta.com/Andalucia.Spain
