JLL SQL Interview Question - Get Employee Name whose salary is greater than Manager Salary
Автор: Cloud Challengers
Загружено: 2024-05-31
Просмотров: 4719
One of the SQL questions recently asked in JLL interview.
Given us Employee table, Get Employee Name whose salary is greater than Manager Salary.
In order to solve this questions, we use SQL Joins.
Let us create Customer table and insert records
CREATE TABLE employees_tbl (empid INT,ename VARCHAR(50),salary INT,managerid INT)
INSERT INTO employees_tbl VALUES (1, 'John', 50000, NULL), (2, 'Alice', 40000, 1),(3, 'Bob', 70000, 1), (4, 'Emily', 55000, NULL), (5, 'Charlie', 65000, 4),
(6, 'David', 50000, 4)
For more SQL interview questions. Check out our playlist.
• SQL Interview Questions
Contact us:
[email protected]
Follow us on
Instagram : instagram.com/cloudchallengers
Facebook : facebook.com/cloudchallengers
LinkedIn : linkedin.com/company/cloudchallengers
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
