Scribd
Upload
281 views1 page

Assignment On Logical Operator

The document contains 20 queries requesting details of employees based on various criteria such as department, job type, salary amount, hire date and more. Specifically, it asks for names, hire dates, details and salaries of employees working as managers, clerks, salespeople and analysts across various departments earning within certain salary ranges and periods of hire.

Uploaded by

Deepti Sharma
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
281 views1 page

Assignment On Logical Operator

The document contains 20 queries requesting details of employees based on various criteria such as department, job type, salary amount, hire date and more. Specifically, it asks for names, hire dates, details and salaries of employees working as managers, clerks, salespeople and analysts across various departments earning within certain salary ranges and periods of hire.

Uploaded by

Deepti Sharma
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

1.

WAQTD DETAILS OF THE EMPLOYEES WORKING AS CLERK AND EARNING LESS THAN 1500
[Link] NAME AND HIREDATE OF THE EMPLOYEES WORKING AS MANAGER IN DEPT 30
[Link] DETAILS OF THE EMP ALONG WITH ANNUAL SALARY IF THEY ARE WORKING IN DEPT
30 AS SALESMAN AND THEIR ANNUAL SALARY HAS
TO BE GREATER THAN 14000.
[Link] ALL THE DETAILS OF THE EMP WORKING IN DEPT 30 OR AS ANALYST
[Link] NAMES OF THE EMPMLOYEES WHOS SALARY IS LESS THAN 1100 AND THEIR
DESIGNATION IS CLERK
[Link] NAME AND SAL , ANNUAL SAL AND DEPTNO IF DEPTNO IS 20 EARNING MORE THAN
1100 AND ANNUAL SALARY EXCEEDS 12000
[Link] EMPNO AND NAMES OF THE EMPLOYEES WORKING AS MANAGER IN DEPT 20
[Link] DETAILS OF EMPLOYEES WORKING IN DEPT 20 OR 30 .
[Link] DETAILS OF EMPLOYEES WORKING AS ANALYST IN DEPT 10 .
[Link] DETAILS OF EMPLOYEE WORKING AS PRESIDENT WITH SALARY OF RUPEES 4000
[Link] NAMES AND DEPTNO , JOB OF EMPS WORKING AS CLERK IN DEPT 10 OR 20
[Link] DETAILS OF EMPLOYEES WORKING AS CLERK OR MANAGER IN DEPT 10 .
[Link] NAMES OF EMPLOYEES WORKING IN DEPT 10 , 20 , 30 , 40 .
[Link] DETAILS OF EMPLOYEES WITH EMPNO 7902,7839.
[Link] DETAILS OF EMPLOYEES WORKING AS MANAGER OR SALESMAN OR CLERK
[Link] NAMES OF EMPLOYEES HIRED AFTER 81 AND BEFORE 87
[Link] DETAILS OF EMPLOYEES EARNING MORE THAN 1250 BUT LESS THAN 3000
[Link] NAMES OF EMPLOYEES HIRED AFTER 81 INTO DEPT 10 OR 30
[Link] NAMES OF EMPLOYEES ALONG WITH ANNUAL SALARY FOR THE EMPLOYEES WORKING
AS MANAGER OR CLERK INTO DEPT 10 OR 30
[Link] ALL THE DETAILS ALONG WITH ANNUAL SALARY IF SAL IS BETWEEN 1000 AND 4000
ANNUALSALARY MORE THAN 15000

You might also like