PART 1 SQL QUERIES ASKED IN FAANG AND MNCs Companies
Write 50+ SQL Queries asked in FAANG and MNCs.
-----------------------------------------------------------------------------------------------------------------------------------------
-------------FIND OUT THE DETAILS OF THE EMPLOYEES WHOSE SALARY IS MORE THAN THEIR MANAGER'S SALARY
-----------------------------------------------------------------------------------------------------------------------------------------
CREATE TABLE Employees (
id INT PRIMARY KEY,
name VARCHAR(255),
salary INT,
managerId INT
);
INSERT INTO Employees (id, name, salary, managerId) VALUES
(1, 'Rahul', 5000, 3),
(2, 'Rohit', 8000, 4),
(3, 'Suresh', 6000, NULL),
(4, 'Manish', 9000, 3);
SELECT * FROM Employees
-----------------------------------------------------------------------------------------------------------------------------------------
------------------HOW TO IDENTIFY THE DUPLICATE DATA AND REMOVE IT USING TWO DIFFERENT METHODS
-----------------------------------------------------------------------------------------------------------------------------------------
CREATE TABLE sales.contacts(
contact_id INT IDENTITY(1,1) PRIMARY KEY,
first_name NVARCHAR(100) NOT NULL,
last_name NVARCHAR(100) NOT NULL,
email NVARCHAR(255) NOT NULL,
);
--INSERT INTO sales.contacts
-- (first_name,last_name,email)
--VALUES
-- ('Syed','Abbas','[email protected]'),
-- ('Catherine','Abel','[email protected]'),
-- ('Kim','Abercrombie','[email protected]'),
-- ('Kim','Abercrombie','[email protected]'),
-- ('Kim','Abercrombie','[email protected]'),
-- ('Hazem','Abolrous','[email protected]'),
-- ('Hazem','Abolrous','[email protected]'),
-- ('Humberto','Acevedo','[email protected]'),
-- ('Humberto','Acevedo','[email protected]'),
-- ('Pilar','Ackerman','[email protected]');
-----------------------------------------------------------------------------------------------------------------------------------------
------------------------------FIND OUT THE DEPARTMENT WISE NTH HIGHEST SALARY--------anything
-----------------------------------------------------------------------------------------------------------------------------------------
CREATE TABLE EMPLOYS
(
ID INT,
NAME VARCHAR(50),
DEPT_ID INT,
SALARY INT,
CITY VARCHAR(50)
)
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO EMPLOYS VALUES(1,'HARSHIT',1,100000,'BHAVNAGAR')
INSERT INTO EMPLOYS VALUES(2,'REKHA',1,90000,'RAJKOT')
INSERT INTO EMPLOYS VALUES(3,'DIMPLE',1,80000,'AHMEDABAD')
INSERT INTO EMPLOYS VALUES(16,'DINO',1,80000,'AHMEDABAD')
INSERT INTO EMPLOYS VALUES(17,'JENY',1,70000,'AHMEDABAD')
INSERT INTO EMPLOYS VALUES(4,'MANOJ',2,120000,'BHAVNAGAR')
INSERT INTO EMPLOYS VALUES(5,'MADHURI',2,150000,'RAJKOT')
INSERT INTO EMPLOYS VALUES(6,'DEEPA',2,65000,'AHMEDABAD')
INSERT INTO EMPLOYS VALUES(18,'MINA',2,5000,'AHMEDABAD')
INSERT INTO EMPLOYS VALUES(7,'MANI',3,120000,'VADODARA')
INSERT INTO EMPLOYS VALUES(8,'MADHU',3,170000,'BANGALORE')
INSERT INTO EMPLOYS VALUES(9,'DEEP',3,66000,'VAPI')
INSERT INTO EMPLOYS VALUES(19,'RIMA',3,56000,'VAPI')
INSERT INTO EMPLOYS VALUES(10,'DHARMESH',4,20000,'BHAVNAGAR')
INSERT INTO EMPLOYS VALUES(11,'SAGAR',4,50000,'RAJKOT')
INSERT INTO EMPLOYS VALUES(12,'POOJA',4,5500,'COIMBATORE')
INSERT INTO EMPLOYS VALUES(20,'PJJ',4,4500,'COIMBATORE')
INSERT INTO EMPLOYS VALUES(13,'SEEMA',5,22000,'RAMESHWARAM')
INSERT INTO EMPLOYS VALUES(14,'SEM',5,11000,'LALBAGU')
INSERT INTO EMPLOYS VALUES(15,'PJVALA',5,10500,'COIMBATORE')
INSERT INTO EMPLOYS VALUES(21,'DJVALA',5,10000,'COIMBATORE')
-----------------------------------------------------------------------------------------------------------------------------------------