Q. How to display employee records who gets more salary than the average salary in the department?
Select * from employee where salary>(select avg(salary) from dept, employee where dept.deptno = employee.deptno;
Data Visualisation Aurora
Hadoop and Big Data
Agile and SAFE
New York, NY 10012, US
© Copyright 2018-2020 www.madanswer.com. All rights reserved. Developed by Madanswer.