Scribd
Upload
4 views5 pages

Between

The document contains various queries related to employee data, including hiring dates, job titles, departments, and salary information. It specifies conditions for filtering employees, such as excluding certain job titles or years of hire. The results of these queries include names and details of employees meeting the specified criteria.

Uploaded by

sanketjadhav0267
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
4 views5 pages

Between

The document contains various queries related to employee data, including hiring dates, job titles, departments, and salary information. It specifies conditions for filtering employees, such as excluding certain job titles or years of hire. The results of these queries include names and details of employees meeting the specified criteria.

Uploaded by

sanketjadhav0267
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

BETWEEN

1] WAQTD NAMES OF AN EMP HIRED AFTER 1981 AND BEFORE


1987.

ENAME
----------
MILLER

2] WAQTD DETAILS OF AN EMP EXCLUDING THE EMP'S WORKING


IN DEPTNO 10 OR 20.

6 rows selected.

3] WAQTD DETILS OF AN EMP EXCEPT PRESIDENT OR MANAGER.

10 rows selected.

4] WAQTD NAMES OF AN EMP WORKING IN DEPTNO 10 OR 20


EXCEPT CLERK OR SALESMAN.

ENAME
----------
JONES
CLARK
SCOTT
KING
FORD

5] WAQTD DETAILS OF EMP EXCLUDING THE EMP'S HIRED IN THE


YEAR 1981.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO


-------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10

6] WAQTD NAMES OF AN EMP HIRED AFTER 1980 & BEFORE 1987


EXCLUDING THE EMP'S HIRED IN THE YEAR 1982.

10 rows selected.

7] WAQTD NAMES OF AN EMP WORKING AS PRESIDENT OR


ANALYST IN DEPTNO 10 OR 20.
ENAME
----------
SCOTT
KING
FORD
8] WAQTD DETAILS OF AN EMP HIRED IN THE YEAR 1987.

EMPNO ENAME JOB MGR HIREDATE SAL COMM


DEPTNO
------- ---------- --------- ---------- --------- ---------- ---------- ----------
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7876 ADAMS CLERK 7788 23-MAY-87 1100 20

9] WAQTD NAMES OF AN EMP WORKING AS MANAGER OR


ANALYST OR PRESIDENT IN DEPTNO 10 OR 20 & EARNING MORE
THAN 2900.

ENAME
----------
JONES
SCOTT
KING
FORD

10] WAQTD NAMES OF AN EMP WORKING AS A SALESMAN OR


MANAGER IN DEPT NO 10 OR 30 & HIRED IN THE YEAR 1981 &
GETS THE COMMISSION OF 1400.
ENAME
----------
MARTIN

11] WAQTD NAMES OF AN EMP WORKING AS A PRESIDENT OR


SALESMAN OR CLERK IN DEPTNO 10 OR 30 & HIRED AFTER 1980
BEFORE 1983 & EARNS SALARY MORE THAN 3000.

ENAME
----------
KING

12] WAQTD DETAILS OF EMP ALONG WITH ANNUAL SAL IF THE


EMP IS WORKING AS MANAGER OR PRESIDENT IN DEPTNO 10 OR
30 & HIRED IN THE YEAR 1981 & HE GETS THE SALARY 2850RPS.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO SAL*12


--------- ---------- --------- ---------- --------- ---------- ---------- ---------- ----------
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 34200

You might also like