Sunday, July 28, 2013

Find maximum salary in each department

we will use the table displayed below for further post unless and otherwise mentioned. table emp contains five column eno(employee number),ename(employee name),sal(employee salary),deptno(employee's department number),mgr(employee's manager number).

the below query displays name of each employee,salary and deptno who are having maximum salary in their department.