Sunday, January 20, 2013

Ways to sort data on a select statement in MSD 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.