Scenario based QA| Get 2nd Highest salary | Oracle SQL Question part 45

Опубликовано: 14 Май 2026
на канале: Shoba Tec Learning

In our video describe on Oracle SQL Interview Question and Answers.
Scenario based QA| Get 2nd Highest salary | Oracle SQL Question part 45

create table emp(id number,name varchar2(20),Dept varchar2(20),Basesal number);

insert into emp values(1,'ABC','X',1000);
insert into emp values(2,'CBD','X',1200);
insert into emp values(3,'DEF','Y',1500);

SELECT * FROM EMP;

CREATE TABLE SALARY(ID NUMBER,MONTH VARCHAR2(20),VARSAL NUMBER,TOTSAL NUMBER);

INSERT INTO SALARY VALUES(1,'APR',100,1100);
INSERT INTO SALARY VALUES(1,'MAY',120,1120);
INSERT INTO SALARY VALUES(1,'JUNE',90,1090);
INSERT INTO SALARY VALUES(2,'APRIL',50,1250);
INSERT INTO SALARY VALUES(2,'MAY',70,1270);
INSERT INTO SALARY VALUES(2,'JUNE',55,1255);
INSERT INTO SALARY VALUES(3,'APR',110,1610);
INSERT INTO SALARY VALUES(3,'MAY',120,1620);
INSERT INTO SALARY VALUES(3,'JUNE',140,1640);

COMMIT;

SELECT * FROM SALARY;