Scribd
Upload
6 views2 pages

Questions

The document outlines various SQL queries related to employee data, focusing on logical operators, normal questions, expressions, and special operators. It includes requests for employee details based on job titles, salaries, departments, and specific conditions such as hire dates and commission status. The queries aim to extract comprehensive information from the employee and department tables for analysis.

Uploaded by

M.varsha M.varsha
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
6 views2 pages

Questions

The document outlines various SQL queries related to employee data, focusing on logical operators, normal questions, expressions, and special operators. It includes requests for employee details based on job titles, salaries, departments, and specific conditions such as hire dates and commission status. The queries aim to extract comprehensive information from the employee and department tables for analysis.

Uploaded by

M.varsha M.varsha
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

******************LOGICAL OPERATORS********************

WAQTD DETAILS OF THE EMPLOYEES WORKING AS CLERK AND


EARNING LESS THAN 1500
WAQTO NAME AND HIREDATE OF THE EMPLOYEES WORKING AS
MANAGER IN DEPT 30
WAQTD DETAILS OF THE EMP ALONG WITH ANNUAL SALARY IF
THEY ARE SALESMAN AND ANNUAL SALARY >18000
WAQTD ALL THE DETAILS OF THE EMP WORKING IN DEPT 30 OR AS
ANALYST
WAQTD NAMES AND DEPTNO OF EMPS WORKING AS CLERK IN
DEPT 10 OR 20
WAQTD DETAILS OF EMPLOYEES WORKING AS CLERK OR
MANAGER IN DEPT 20
WAQTD EMPNO AND NAMES OF THE EMPLOYEES WORKING AS
MANAGER IN DEPT 20
************** NORMAL QUESTIONS****************************
WRITE A QUERY TO DISPLAY ALL THE DETAILS FROM THE
EMPLOYEE TABLE.
WAQTD NAMES OF ALL THE EMPLOYEES.
WAQTD NAME AND SALARY GIVEN TO ALL THE EMPLOYEES.
WAQTD NAME AND COMMISSION GIVEN TO ALL THE EMPLOYEES.
WAQTD ENAME AND HIREDATE OF ALL THE EMPLOYEES.
WAQTD DNAMES PRESENT IN DEPARTMENT TABLE.
WAQTD DNAME AND LOCATION PRESENT IN DEPT TABLE.
***************EXPRESSION AND ALIAS***********
WAQTD NAME OF THE EMPLOYEE ALONG WITH THEIR ANNUAL
SALARY.
WAQTD ENAME AND JOB FOR ALL THE EMPLOYEE WITH THEIR
HALF TERM SALARY.
WAQTD NAME SALARY AND SALARY WITH A HIKE OF 10%.
WAQTD NAME AND SALARY WITH DEDUCTION OF 25%.
WAQTD TOTAL SALARY GIVEN TO EACH EMPLOYEE (SAL+COMM).
WAQTD ANNUAL SALARY OF EMPLOYEES WITH 10% DEDUCTION.
*************WHERE CLAUSE******************
WAQTD THE ANNUAL SALARY OF THE EMPLOYEE WHOS NAME IS
SMITH
WAQTD NAME OF THE EMPLOYEES WORKING AS CLERK
WAQTD DETAILS OF THE EMP WHO EARNS MORE THAN 2000
WAQTD DETAILS OF THE EMP WHO WAS HIRED AFTER 01-JAN-81
WAQTD EMPNO OF THE EMPLOYEES WHO ARE WORKING IN DEPT
30
WAQTD ENAME AND HIREDATE IF THEY ARE HIRED BEFORE 1981
WAQTD DETAILS OF EMPLOYEES HAVING COMMISSION MORE
THAN SALARY
*************SPECIAL OPERATORS***********
LIST ALL THE EMPLOYEES WHOSE COMMISSION IS NULL.
LIST ALL THE EMPLOYEES WHO DON'T HAVE A REPORTING
MANAGER
LIST ALL THE EMPLOYEES WHOSE NAME STARTS WITH 'S'.
LIST ALL THE EMPLOYEES EXCEPT THOSE WHO ARE WORKING IN
DEPT 10 & 20.
LIST ALL THE SALESMEN IN DEPT NUMBER 30 AND HAVING
SALARY GREATER THAN 1500
LIST ALL THE ANALYST IN DEPT NUMBER 20 AND HAVING SALARY
GREATER THAN 2500.
LIST ALL THE EMPLOYEES WHOSE NAME DOES NOT END WITH 'ES'
OR 'R'.
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.

You might also like