0 votes
in Oracle by

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

1 Answer

0 votes
by

Ans is:- 

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

Related questions

0 votes
asked May 13, 2020 in Oracle by AdilsonLima
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...