SQL Interview Question | 03 |
If you like this video please
like share , subscribe and comment down below..
if you have any suggestion or doubt this video.
Script:
CREATE TABLE Employee (
id INT PRIMARY KEY,
name VARCHAR(50),
department VARCHAR(50),
managerId INT
);
INSERT INTO Employee (id, name, department, managerId) VALUES
(1, 'John', 'HR', NULL),
(2, 'Bob', 'HR', 1),
(3, 'Olivia', 'HR', 1),
(4, 'Emma', 'Finance', NULL),
(5, 'Sophia', 'HR', 1),
(6, 'Mason', 'Finance', 4),
(7, 'Ethan', 'HR', 1),
(8, 'Ava', 'HR', 1),
(9, 'Lucas', 'HR', 1),
(10, 'Isabella', 'Finance', 4),
(11, 'Harper', 'Finance', 4),
(12, 'Hemla', 'HR', 3),
(13, 'Aisha', 'HR', 2),
(14, 'Himani', 'HR', 2),
(15, 'Lily', 'HR', 2);
#sql
#plsql
#trend
#sqlqueryinterviewquestionsandanswers
#sqlinterview
#tcs
#infosys
#deloitte
#postgresql
#sqlserver
#oraclesql
#hcl
#2024
#2025
#india
#capgemini
#infosys
#hcl
#data engineer
#data analyst
#data science