How to Find Employees Earning More Than Their Managers in SQL
"In this video, we'll tackle a common scenario in the workplace: identifying employees who earn more than their reporting managers. We'll start by creating a table with employee data, insert some sample records, and then write a SQL query to find those high-earning employees. This is a must-know SQL trick for anyone working with HR databases or performing salary comparisons. Perfect for beginners and intermediate SQL learners alike. Watch now to level up your SQL skills!"
These details should help in creating an engaging and informative video!
--Your HR team has to know who the employees who make more than their reporting managers do so that they can
properly raise their pay during the assessment cycle.
Could you check the table and create a SQL query for this please?
drop table Employees
-- Create the Employees table
CREATE TABLE Employees (
EmpID INT PRIMARY KEY,
EmpName VARCHAR(100),
ManagerID INT,
EmpSalary DECIMAL(10, 2)
);
-- Insert sample data
INSERT INTO Employees (EmpID, EmpName, ManagerID, EmpSalary) VALUES
--(1, 'Alice', 3, 70000), -- Employee earning more than their manager
--(2, 'Bob', 3, 60000),
--(3, 'Charlie', 5, 80000), -- Manager
--(4, 'David', 3, 65000),
--(5, 'Eve', NULL, 120000)
(6, 'Vijat', 3, 99000)-- CEO, has no manager
-- Query to find employees who earn more than their reporting managers
select * from Employees
select e.empid,e.empname,e.empsalary,m.empname as managername,m.empsalary as managersalary
from Employees e join
Employees m on e.managerid=m.empid
where e.empsalary(greaterthan)m.empsalary
SQL Interview Problem: Splitting Full Names into First, Middle, and Last Names
• SQL Interview Problem: Splitting Full Name...
Top SQL Interview Questions: RANK, DENSE_RANK, ROW_NUMBER Explained
• Top SQL Interview Questions: RANK, DENSE_R...
Top 3 Products by Sales & Employees by Salary | SQL Ranking Functions Explained
• Top 3 Products by Sales & Employees by Sal...
SQL Interview Challenge: Find Hidden Likes in Your Friends' Favorites!
• SQL Interview Challenge: Find Hidden Likes...
SQL Magic: Aggregating Marks & Delivery Dates with Advanced Queries!
• SQL Magic: Aggregating Marks & Delivery Da...
Top 20% vs Bottom 20% of Students in SQL: NTILE vs TOP PERCENT
• Top 20% vs Bottom 20% of Students in SQL: ...
SQL Tricks: Find the 3rd Lowest Salary in Each Department with Two Powerful Methods!
• SQL Tricks: Find the 3rd Lowest Salary in ...
SQL Tutorial: Find Employees Who Joined Before Their Managers
• SQL Tutorial: Find Employees Who Joined Be...
SQL Tutorial: Retrieve Specific Rows with OFFSET & ROW_NUMBER - Top 2 Methods Compared!
• SQL Tutorial: Retrieve Specific Rows with ...
How to Build a Location-Based Hierarchy in SQL | Recursive Query Tutorial
• How to Build a Location-Based Hierarchy in...
How to Count Weekends in Any Month Using SQL Server: A Step-by-Step Guide
• How to Count Weekends in Any Month Using S...
SQL Date Magic: Find & Format the Last Day of the Previous Month
• SQL Date Magic: Find & Format the Last Day...
How to Count Workdays in SQL: Two Effective Methods Explained!
• How to Count Workdays in SQL: Two Effectiv...
#SQL
#Database
#SQLTutorial
#EmployeeManagement
#SalaryComparison
#SQLQuery
#ManagerSalary
#EmployeeSalary
#SQLSelfJoin
#DataAnalysis