Scribd
Upload
1 views5 pages

Nested Sub Query

The document contains a series of SQL queries that retrieve specific employee information from a database. It includes queries for names of employees based on salary rankings, hiring dates, department numbers, and job designations. Additionally, it provides details for employees with specific attributes, such as location and department name.

Uploaded by

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

Nested Sub Query

The document contains a series of SQL queries that retrieve specific employee information from a database. It includes queries for names of employees based on salary rankings, hiring dates, department numbers, and job designations. Additionally, it provides details for employees with specific attributes, such as location and department name.

Uploaded by

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

NESTED_SUB_QUERY

1] WAQTD NAME OF AN EMP EARNING 2ND MAX SAL.

ENAME
-----
SCOTT
FORD

2] WAQTD NAME OF EMP WHO ARE EARNING MORE THAN WARD & WORKING
IN SAME DEPTNO AS THAT OF BLAKE & HIRED BEFORE TURNER.

ENAME
-------
BLAKE
ALLEN

3] WAQTD NAMES OF AN EMP HIRED AFTER SMITH, BEFORE MILLER & WORKING
IN SAME DESIGNATION AS THAT OF JONES IN SALES DEPTARTMENT.

ENAME
---------
BLAKE
4] WAQTD NAMES OF AN EMP EARNING LESS THAN KING & HIRED BEFORE
MILLER IN NEW YORK.

ENAME
----------
CLARK

5] WAQTD NAME OF EMP EARNING 3RD MIN SAL.

ENAME
-----
ADAMS

6] WAQTD LOC OF AN EMP EARNING 3RD MAX SAL.

LOC
-----
DALLAS

7] WAQTD NAMES OF EMP HIRED LAST.

ENAME
------
ADAMS
8] WAQTD NAME OF THE AN EMP HIRED 2ND.

ENAME
-------
ALLEN

9] WAQTD LOC OF EMP HIRED 2ND LAST.

LOC
---------
DALLAS

10] WAQTD NAME OF THE EMP EARNING 5TH MIN SAL.

ENAME
------
MILLER

11] WAQTD LOCATION OF AN EMP EARNING 2ND MIN SAL.

LOC
------
CHICAGO
12] WAQTD NAME OF AN EMP EARNING 4TH MIN SAL.

ENAME
-------
MARTIN

13] WAQTD DNAME OF EMP WHOSE NAME IS SMITH.

DNAME
-------
RESEARCH

14] WAQTD DNAME, LOC OF THE EMP'S WHOSE NAME IS KING.

DNAME LOC
-------------- ----------
ACCOUNTING NEW YORK

15] WAQTD LOC OF EMP WHOSE EMPNO IS 7902.

LOC
---------
DALLAS
16] WAQTD DETAILS OF AN EMP WORKING AS PRESIDENT AND EARNING MORE
THAN SCOTT AND HIRED AFTER SMITH.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO


------ ---------- --------- ---------- --------- ---------- ---------- ----------
7839 KING PRESIDENT 17-NOV-81 5000 10

You might also like