Software Applications Programming Errors and solutions.

Following is example of using group by clause in select query using axapta. Group by clause will display data as per mentioned fields after group by clause. SELECT D.DNO ,D.DNAME ,D.DLOCATION , Max(E.salary) FROM Emp E, Dept D                                                       where E.Dno = D.Dno                                                      Group by E.Dno, D.Dno, D.DNAME ,D.DLOCATION ; when you use group by clause then you will get distinct records ...