Scribd
Upload
125 views3 pages

Waqtd 2Nd Minimum Salary

The document contains a series of SQL queries using Oracle-style syntax to retrieve various employee and department data from EMP and DEPT tables. It includes queries for finding minimum and maximum salaries, employee hire dates, and department names related to specific salary criteria. Each query is designed to address specific assignment questions numbered 61 to 70.

Uploaded by

Monica N
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
125 views3 pages

Waqtd 2Nd Minimum Salary

The document contains a series of SQL queries using Oracle-style syntax to retrieve various employee and department data from EMP and DEPT tables. It includes queries for finding minimum and maximum salaries, employee hire dates, and department names related to specific salary criteria. Each query is designed to address specific assignment questions numbered 61 to 70.

Uploaded by

Monica N
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Here are the nested subquery-based SQL queries for your assignment questions 61–70.

These use Oracle-style syntax assuming you have the standard EMP and DEPT tables.

61. WAQTD 2ND MINIMUM SALARY


SELECT MIN(SAL)
FROM EMP
WHERE SAL > (SELECT MIN(SAL) FROM EMP);

62. WAQTD 5TH MAXIMUM SALARY


SELECT MIN(SAL)
FROM EMP
WHERE SAL IN (
SELECT DISTINCT SAL
FROM EMP
ORDER BY SAL DESC
FETCH FIRST 5 ROWS ONLY
);

Alternative if FETCH is not supported:

SELECT SAL FROM (


SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC
) WHERE ROWNUM <= 5
MINUS
SELECT SAL FROM (
SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC
) WHERE ROWNUM <= 4;

63. WAQTD NAME OF THE EMPLOYEE EARNING 3RD MAXIMUM


SALARY
SELECT ENAME
FROM EMP
WHERE SAL = (
SELECT MIN(SAL) FROM (
SELECT DISTINCT SAL
FROM EMP
ORDER BY SAL DESC
FETCH FIRST 3 ROWS ONLY
)
);

64. WAQTD EMPNO OF THE EMPLOYEE EARNING 2ND MAXIMUM


SALARY
SELECT EMPNO
FROM EMP
WHERE SAL = (
SELECT MAX(SAL)
FROM EMP
WHERE SAL < (SELECT MAX(SAL) FROM EMP)
);

65. WAQTD DEPARTMENT NAME OF AN EMPLOYEE GETTING 4TH


MAX SAL
SELECT DNAME
FROM DEPT
WHERE DEPTNO = (
SELECT DEPTNO FROM EMP
WHERE SAL = (
SELECT MIN(SAL) FROM (
SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC FETCH FIRST 4
ROWS ONLY
)
)
FETCH FIRST 1 ROWS ONLY
);

66. WAQTD DETAILS OF THE EMPLOYEE WHO WAS HIRED 2ND


SELECT *
FROM EMP
WHERE HIREDATE = (
SELECT MIN(HIREDATE)
FROM EMP
WHERE HIREDATE > (
SELECT MIN(HIREDATE) FROM EMP
)
);

67. WAQTD NAME OF THE EMPLOYEE HIRED BEFORE THE LAST


EMPLOYEE
SELECT ENAME
FROM EMP
WHERE HIREDATE < (
SELECT MAX(HIREDATE) FROM EMP
);

68. WAQTD LOC OF THE EMPLOYEE WHO WAS HIRED FIRST


SELECT LOC
FROM DEPT
WHERE DEPTNO = (
SELECT DEPTNO
FROM EMP
WHERE HIREDATE = (
SELECT MIN(HIREDATE) FROM EMP
)
);
69. WAQTD DETAILS OF THE EMPLOYEE EARNING 7TH MINIMUM
SALARY
SELECT *
FROM EMP
WHERE SAL = (
SELECT MAX(SAL) FROM (
SELECT DISTINCT SAL FROM EMP ORDER BY SAL ASC FETCH FIRST 7 ROWS
ONLY
)
);

70. WAQTD DNAME OF EMPLOYEE GETTING 2ND MAXIMUM


SALARY
SELECT DNAME
FROM DEPT
WHERE DEPTNO = (
SELECT DEPTNO
FROM EMP
WHERE SAL = (
SELECT MAX(SAL)
FROM EMP
WHERE SAL < (SELECT MAX(SAL) FROM EMP)
)
FETCH FIRST 1 ROWS ONLY
);

Let me know if you want these queries converted into a document or formatted for a report or
assignment sheet.

You might also like