Re: [Axapta-Knowledge-Village] Order by & Group by

(403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Anjali Kanna <[EMAIL PROTECTED]> To: axapta-knowledge-village@yahoogroups.com Sent: Monday, March 24, 2008 2:13:05 AM Subject: [Axapta-Knowledge-Village] Order by & Group by Hi To all, Is i

[Axapta-Knowledge-Village] Order by & Group by

Hi To all, Is it possible to use Order by and group by in a single select statement? I want to retreive the records from tabel , so i used the follwoing query while select ItemId,ItemDesc,sum(Cost),sum(Qty) form tmpmodeltable group by ItemId //Order by qty desc { element.exec