Sunday, July 26, 2020

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

  Printing Number Pattern using SQL Link for video answer: SQL: --********************* --PRINT Pattern --********************* -- 1 -- ...