💡 SQL Interview Question: 👉 How do you display employees along with their managers? This is one of the most asked SQL questions to test self-join concepts. Here’s the clean SQL query 👇 SELECT e.employee_name AS employee, m.employee_name AS manager FROM employees e LEFT JOIN employees m ON e.manager_id = m.employee_id; 🎯 Explanation: - The employees table is joined with itself - e represents employee - m represents manager - manager_id in employee row maps to manager’s employee_id - LEFT JOIN
1:00
💡 SQL Interview Question: 👉 How do you display employees along with …
41 views2 months ago
FacebookAshok IT
SQL Query to Find Second Highest Salary - GeeksforGeeks
SQL Query to Find Second Highest Salary - GeeksforGeeks
6 months ago
geeksforgeeks.org
SQL Interview Questions and Answers
SQL Interview Questions and Answers
36 views2 weeks ago
intellipaat.com
Write SQL Queries for the following: To display employee ids, names of employees, job ids with corresponding job titles.
Write SQL Queries for the following: To display employee ids, names o…
Jun 21, 2020
pathwalla.com
SQL Self Join vs Regular Join | When to Use Self Joins
2:01
SQL Self Join vs Regular Join | When to Use Self Joins
2 months ago
YouTubeScience for the curious mind
LeetCode 181 | Employees Earning More Than Their Managers | SQL Self Join Explained
1:53
LeetCode 181 | Employees Earning More Than Their Managers | SQL …
1 views1 month ago
YouTubeMohd Wasim DSA
Aarti Sinha on Instagram: "Day 5/7 - SQL Challenge 🎯 TODAY’S QUESTION: Find all employees who earn more than their manager. TABLE: Employees (id, name, salary, manager_id) SAMPLE DATA: id | name | salary | manager_id —|———|———|———— 1 | Alice | 90000 | NULL (CEO) 2 | Bob | 80000 | 1 3 | Charlie | 95000 | 1 ← Earns more than Alice! 4 | Diana | 70000 | 2 THE SOLUTION: SELECT e.name as employee_name FROM Employees e JOIN Employees m ON e.manager_id = m.id WHERE e.salary > m.salary; BREAKDOWN: Emplo
0:39
Aarti Sinha on Instagram: "Day 5/7 - SQL Challenge 🎯 TODAY’S QUESTI…
11.7K views1 month ago
Instagramaartii.py
5:28
Query Manager Fundamentals - 1
2.3K viewsApr 17, 2015
YouTubeLen Krukowski
57:43
How to Create an Employee Database Management System in …
47.3K viewsApr 12, 2020
YouTubeDJ Oamen
9:56
DBMS - Relational Algebra Questions with Solution - Part 1.
377.2K viewsMar 16, 2021
YouTubeWeb Tech Paradise
21:28
DBMS - Relational Algebra Questions with Solution - Part 2
135.5K viewsMar 31, 2021
YouTubeWeb Tech Paradise
11:02
Lec-62: SQL Queries and Subqueries (part-4) | Having claus…
829.9K viewsSep 18, 2018
YouTubeGate Smashers
1:24:51
How to Create Employee Payroll Management System with MySQL …
10.2K viewsJun 28, 2020
YouTubeDJ Oamen
6:53
SSMS Server Name Not Showing | Fixed
123.3K viewsNov 1, 2020
YouTubeTECHINSPEC
7:38
Mr Excel & excelisfun Trick 139: Formula To List Employees By De…
51.5K viewsSep 13, 2013
YouTubeexcelisfun
11:45
Part 1 How to find nth highest salary in sql
2.1M viewsMay 17, 2014
YouTubekudvenkat
1:02:19
How to Create an Employee Database Management Systems u…
29.6K viewsJan 7, 2019
YouTubeDJ Oamen
10:14
Part 2 SQL query to get organization hierarchy
585.7K viewsMay 19, 2014
YouTubekudvenkat
5:00
L94: Solved Question(1) on SQL Queries - Employee, Works, Comp…
258.1K viewsNov 15, 2016
YouTubeEasy Engineering Classes
4:15
Department Wise Highest Salary | Ep-2 | Top 20 SQL Interview Quest…
210.5K viewsSep 18, 2019
YouTubeGeeksforGeeks
6:23
SQL Query | How to find employees hired in last n months | Datediff
65.6K viewsFeb 2, 2021
YouTubeLearn at Knowstar
4:03
Part 8 SQL Query to find department with highest number of employees
262.4K viewsJun 14, 2014
YouTubekudvenkat
5:50
SQL Query to find Employee with maximum salary in each departme…
30.1K viewsJun 22, 2021
YouTubeCoding Glitz
6:57
SQL Query | How to find employees with salary greater than their man…
11.8K viewsNov 26, 2020
YouTubeLearn at Knowstar
6:54
SQL Query | How to increment salaries of employees who have 2 …
11.2K viewsNov 27, 2020
YouTubeLearn at Knowstar
5:18
SQL- Find employees with salary less than Dept average but more t…
11.5K viewsNov 25, 2020
YouTubeLearn at Knowstar
0:46
BigDataByte on Instagram: "Question: Consider a table name…
275.1K viewsMar 5, 2024
Instagrambigdatabyte
6:34
SQL #1 How to display Manager names from Employee Table
5.9K viewsJun 9, 2020
YouTubeArun Videos
3:02
SQL Query To Fetch Employees Who Are Also Managers | Self Joi…
43.8K viewsMay 17, 2021
YouTubeCrack Concepts
21:39
Relational Algebra Queries (Part 1)
186.1K viewsNov 11, 2021
YouTubeNeso Academy
See more videos
Static thumbnail place holder