Scribd
Upload
1K views1 page

Sub Query 1

The document contains 10 SQL queries with subqueries that select employee data from a database table based on various conditions like salary, hire date, department, and job. The queries find employees earning more than Adams, less than King, in the same department or job as Jones, hired before Scott, and more.

Uploaded by

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

Sub Query 1

The document contains 10 SQL queries with subqueries that select employee data from a database table based on various conditions like salary, hire date, department, and job. The queries find employees earning more than Adams, less than King, in the same department or job as Jones, hired before Scott, and more.

Uploaded by

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

1. WAQTD NAME OF EMPLOYEES EARNING MORE THAN ADAMS.

SELECT ENAME FROM EMP WHERE SAL>(SELECT SAL FROM EMP WHERE ENAME='ADAMS');

2. WAQTD NAME AND SALARY OF THE EMPLOYEES EARNING LESS THAN KING.
SELECT ENAME,SAL FROM EMP WHERE SAL<(SELECT SAL FROM EMP WHERE ENAME='KING');

3. WAQTD NAME AND DEPTNO OF THE EMPLOYEES IF THEY ARE WORKING IN SAME DEPT AS
JONES.
SELECT ENAME,DEPTNO FROM EMP WHERE DEPTNO=(SELECT DEPTNO FROM EMP WHERE
NAME='JONES');

4. WAQTD NAME AND JOB OF ALL THE EMPLOYEES WORKING IN THE SAME DESIGNATION AS
JONEES.
SELECT ENAME,JOB FROM EMP WHERE JOB=(SELECT JOB FROM EMP WHERE NAME='JONES');

5. WAQTD EMPNO AND ENAME ALONG WITH ANNUAL SALARY OF ALL THE EMPLOYEES IF THEIR
ALLUAL SALARY IS GREATER THAN WARDS ANNUAL SALARY.
SELECT EMPNO,ENAME,SAL*12 FROM EMP WHERE SAL*12>(SELECT SAL*12 FROM EMP WHERE
NAME='WARDS');

6. WAQTD NAME AND HIREDATE OF AN EMPLOYEES IF THEY ARE HIRED BEFORE SCOTT.
SELECT ENAME,HIREDATE FROM EMP WHERE HIREDATE<(SELECT HIREDATE FROM EMP WHERE
NAME='SCOTT');

7. WAQTD NAME AND HIREDATE OF EMPLOYEES IF THEY HIRED AFTER THE PRESIDENT.
SELECT ENAME,HIREDATE FROM EMP WHERE HIREDATE>(SELECT HIREDATE FROM EMP WHERE
JOB='PRESIDENT');

8. WAQTD NAME AND SAL OF THE EMPLOYEES IF THEY ARE EARNING SAL LESS THAN
EMPLOYEES WHO’S EMPNO IS 7839.
SELECT ENAME,SAL FROM EMP WHERE SAL<(SELECT SAL FROM EMP WHERE EMPNO=7839);

9. WAQTD ALL DETAILS OF ALL THE EMPLOYEES IF THE EMPLOYEES ARE HIRED BEFORE
MILLER.
SELECT * FROM EMP WHERE HIREDATE<(SELECT HIREDATE FROM EMP WHERE
ENAME='MILLER');

10. WAQTD ENAME AND EMPNO OF THE EMPLOYEES IF EMPLOYEES ARE EARNING MORE THAN
ALLEN.
SELECT ENAME,EMPNO FROM EMP WHERE SAL>(SELECT SAL FROM EMP WHERE
ENAME='ALLLEN');

You might also like