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.
No comments:
Post a Comment