Scribd
Upload
65 views2 pages

Document

The document contains a series of SQL queries aimed at retrieving specific employee data from a database. Each query addresses different conditions such as salary comparisons, department affiliations, job titles, and hire dates. The queries are structured to filter employees based on the attributes of other employees, such as those earning more or less than specified individuals.

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
65 views2 pages

Document

The document contains a series of SQL queries aimed at retrieving specific employee data from a database. Each query addresses different conditions such as salary comparisons, department affiliations, job titles, and hire dates. The queries are structured to filter employees based on the attributes of other employees, such as those earning more or less than specified individuals.

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/ 2

11.

WAQTD ENAME AND SALARY OF ALL THE EMPLOYEES WHO ARE


EARNING MORE THAN MILLER BUT LESS THAN ALLEN

SELECT ENAME, SAL


FROM EMP
WHERE SAL > (SELECT SAL FROM EMP WHERE ENAME = 'MILLER')
AND SAL < (SELECT SAL FROM EMP WHERE ENAME = 'ALLEN');

12. WAQTD ALL THE DETAILS OF THE EMPLOYEES WORKING IN DEPT 20


AND WORKING IN THE SAME DESIGNATION AS SMITH

SELECT *
FROM EMP
WHERE DEPTNO = 20
AND JOB = (SELECT JOB FROM EMP WHERE ENAME = 'SMITH');

13. WAQTD ALL THE DETAILS OF THE EMPLOYEES WORKING AS


MANAGER IN THE SAME DEPT AS TURNER

SELECT *
FROM EMP
WHERE JOB = 'MANAGER'
AND DEPTNO = (SELECT DEPTNO FROM EMP WHERE ENAME = 'TURNER');

14. WAQTD NAME AND HIREDATE OF THE EMPLOYEES HIRED AFTER 1980
AND BEFORE KING

SELECT ENAME, HIREDATE


FROM EMP
WHERE HIREDATE > TO_DATE('01-JAN-1980', 'DD-MON-YYYY')
AND HIREDATE < (SELECT HIREDATE FROM EMP WHERE ENAME = 'KING');

15. WAQTD NAME AND SAL ALONG WITH ANNUAL SAL FOR ALL
EMPLOYEES WHOS SAL IS LESS THAN BLAKE AND MORE THAN 3500

SELECT ENAME, SAL, SAL * 12 AS ANNUAL_SAL


FROM EMP
WHERE SAL < (SELECT SAL FROM EMP WHERE ENAME = 'BLAKE')
AND SAL > 3500;

16. WAQTD ALL THE DETAILS OF EMPLOYEES WHO EARN MORE THAN
SCOTT BUT LESS THAN KING

SELECT *
FROM EMP
WHERE SAL > (SELECT SAL FROM EMP WHERE ENAME = 'SCOTT')
AND SAL < (SELECT SAL FROM EMP WHERE ENAME = 'KING');

17. WAQTD NAME OF THE EMPLOYEES WHOSE NAME STARTS WITH 'A'
AND WORKS IN THE SAME DEPT AS BLAKE

SELECT ENAME
FROM EMP
WHERE ENAME LIKE 'A%'
AND DEPTNO = (SELECT DEPTNO FROM EMP WHERE ENAME = 'BLAKE');

18. WAQTD NAME AND COMM IF EMPLOYEES EARN COMMISSION AND


WORK IN THE SAME DESIGNATION AS SMITH

SELECT ENAME, COMM


FROM EMP
WHERE COMM IS NOT NULL
AND JOB = (SELECT JOB FROM EMP WHERE ENAME = 'SMITH');

19. WAQTD DETAILS OF ALL THE EMPLOYEES WORKING AS CLERK IN THE


SAME DEPT AS TURNER

SELECT *
FROM EMP
WHERE JOB = 'CLERK'
AND DEPTNO = (SELECT DEPTNO FROM EMP WHERE ENAME = 'TURNER');

20. WAQTD ENAME, SAL AND DESIGNATION OF THE EMPLOYEES WHOSE


ANNUAL SALARY IS MORE THAN SMITH AND LESS THAN KING

SELECT ENAME, SAL, JOB


FROM EMP
WHERE SAL * 12 > (SELECT SAL * 12 FROM EMP WHERE ENAME = 'SMITH')
AND SAL * 12 < (SELECT SAL * 12 FROM EMP WHERE ENAME = 'KING');

You might also like