Write SQL command to display name of worker whose salary is more than 90000
Answers
Answered by
1
Answer:
Determine the name of employees, who take the highest salary in their departments. SQL> select ename,deptno,sal from emp where sal in(select max(sal) from emp group by deptno);
Explanation:
Similar questions