Microsoft Dynamics Axapta Technical,Functional Coverage

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.