Find Employees With Salary Lower Than Their Department Average
Part - 13
Click below for you tube Answer
In the above query there are 3 parts:
Part 1: Deriving the average salary of the department
Part 2: Joining the tblEmployee table to the derived table on Department id
Part 3: Applying the filter condition to pick employees whose salary is less than average dept salary
No comments:
Post a Comment