in Oracle by

Q. How to display employee records who gets more salary than the average salary in the department?

► Click here to show 1 Answer

0 votes

Ans is:- 

Select * from employee where salary>(select avg(salary) from dept, employee where dept.deptno = employee.deptno;

Learn More with Madanswer

Related questions

0 votes
asked May 13, 2020 in Oracle by AdilsonLima