[go: up one dir, main page]
Scribd
Upload
31 views3 pages

Assignment On Sepcial Operators

The document outlines a series of assignment tasks focused on querying employee data using special operators. It includes various conditions such as filtering by commission, reporting managers, department numbers, salary ranges, and employee names. Additionally, it provides contact information for assistance in case of errors.

Uploaded by

snehal medhe
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
31 views3 pages

Assignment On Sepcial Operators

The document outlines a series of assignment tasks focused on querying employee data using special operators. It includes various conditions such as filtering by commission, reporting managers, department numbers, salary ranges, and employee names. Additionally, it provides contact information for assistance in case of errors.

Uploaded by

snehal medhe
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
You are on page 1/ 3

ASSIGNMENT ON SEPCIAL OPERATORS :

1) LIST ALL THE EMPLOYEES WHOSE COMMISSION IS

NULL

2) LIST ALL THE EMPLOYEES WHO DON’T HAVE A

REPORTING MANAGER

3) LIST ALL THE SALESMEN IN DEPT 30

4) LIST ALL THE SALESMEN IN DEPT NUMBER 30 AND

HAVING SALARY GREATER THAN 1500

5) LIST ALL THE EMPLOYEES WHOSE NAME STARTS

WITH ‘S’ OR ‘A’

6) LIST ALL THE EMPLOYEES EXCEPT THOSE WHO ARE

WORKING IN DEPT 10 & 20.

7) LIST THE EMPLOYEES WHOSE NAME DOES NOT START

WITH ‘S’

8) LIST ALL THE EMPLOYEES WHO ARE HAVING

REPORTING MANAGERS IN DEPT 10

9) LIST ALL THE EMPLOYEES WHOSE COMMISSION IS

NULL AND WORKING AS CLERK

10) LIST ALL THE EMPLOYEES WHO DON’T HAVE A

REPORTING MANAGER IN DEPTNO 10 OR 30.


11) LIST ALL THE SALESMEN IN DEPT 30 WITH SAL MORE

THAN 2450

12) LIST ALL THE ANALYST IN DEPT NUMBER 20 AND

HAVING SALARY GREATER THAN 2500

13) LIST ALL THE EMPLOYEES WHOSE NAME STARTS

WITH ‘M’ OR ‘J’

14) LIST ALL THE EMPLOYEES WITH ANNUAL SALARY

EXCEPT THOSE WHO ARE WORKING IN DEPT 30

15) LIST THE EMPLOYEES WHOSE NAME DOES NOT END

WITH ‘ES’ OR ‘R’

16) LIST ALL THE EMPLOYEES WHO ARE HAVING

REPORTING MANAGERS IN DEPT 10 ALONG WITH 10%

HIKE IN SALARY

17) DISPLAY ALL THE EMPLOYEE WHO ARE

‘SALESMAN’S HAVING ‘E’ AS THE LAST BUT ONE

CHARACTER IN ENAME BUT SALARY HAVING EXACTLY

4 CHARACTER.

18) DISPLAY ALL THE EMPLOYEE WHO ARE JOINED

AFTER YEAR 81.

19) DISPLAY ALL THE EMPLOYEE WHO ARE JOINED IN

FEB.
20) LIST THE EMPLOYEES WHO ARE NOT WORKING AS

MANAGERS AND CLERKS IN DEPT 10 AND 20 WITH A

SALARY IN THE RANGE OF 1000 TO 3000.

If ur getting errors !!!

Contact me on : 95sharath@gmail.com Or

Send screenshot to INSTAGRAM : sharath_hiremath_95

You might also like