SQL Interview Question Find second highest salary of employee
#SQL #Interview Question Find second #highest #salary of employee
Website; https://vnreedy.weebly.com/
Code for Table:
CREATE TABLE Employee(
[Eid] int,
[Did] int,
[DName] varchar(20),
[Mid] int,
[Salary] int )
INSERT INTO Employee VALUES(1,1,'A',null,100)
INSERT INTO Employee VALUES(2,1,'A',1,100)
INSERT INTO Employee VALUES(3,1,'A',1,90)
INSERT INTO Employee VALUES(4,1,'A',2,80)
INSERT INTO Employee VALUES(5,1,'A',3,70)
INSERT INTO Employee VALUES(6,1,'A',2,60)
INSERT INTO Employee VALUES(7,2,'B',null,120)
INSERT INTO Employee VALUES(8,2,'B',7,100)
INSERT INTO Employee VALUES(9,3,'C',null,120)
INSERT INTO Employee VALUES(10,3,'C',9,130)
INSERT INTO Employee VALUES(11,3,'C',9,120)