Submitted Questions
Asked By: nirmal1in
| Asked On: Feb 24th, 2010
How to get the employee details whose salary is less than the average salary of the department.
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
select emp_name, avg(salary)from employees group by emp_namehaving avg(salary) < (Select avg(salary) &...
SELECT * FROM emp e WHERE sal> (SELECT AVG(sal) FROM emp GROUP BY deptno HAVING deptno=e.deptno) ORDER BY deptno;