Microsoft Dynamics Ax, Application Integration Framework, x++ programming, Ax 2009 , 2012. Enterprise portal, SharePoint , BI Tools, OLAP, OLTP, DAX, SQL database, SSRS,SSIS,SSAS, Workflow.

Sunday, January 20, 2013

Ways to sort data on a select statement in axapta

Using existing indexes on the tables

The order by clause in a select statement that will return records in ascending order by default and if specified, can return them in descending order.

The group by clause in a select statement will group records by a selected field.

No comments:

Post a Comment

Active Search Results Technology Blogs