Scribd
Upload
10 views2 pages

KL_SQL QUESTIONS(PROJECTION - LIKE ) (1)

The document contains a list of SQL questions focused on employee data retrieval using various conditions and operators. It includes queries for employee details based on job titles, salary ranges, hiring dates, and specific character occurrences in names. The questions aim to extract specific information such as names, salaries, and job roles from an employee table.

Uploaded by

aniruddhasai720
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
10 views2 pages

KL_SQL QUESTIONS(PROJECTION - LIKE ) (1)

The document contains a list of SQL questions focused on employee data retrieval using various conditions and operators. It includes queries for employee details based on job titles, salary ranges, hiring dates, and specific character occurrences in names. The questions aim to extract specific information such as names, salaries, and job roles from an employee table.

Uploaded by

aniruddhasai720
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/ 2

KRISHNA_SQLQUES

SQL QUESTIONS

PROJECTION TO LIKE OPERATOR :

1.WAQTD DETAILS OF THE EMPLOYEES WHO ARE WORKING AS A MANAGER OR SALESMAN.

2.WAQTD NAMES OF THE EMPLOYEES WHOES NAME HAS EXACTLY 1 'A' IN THEIR NAME.

3.WAQTD DETAILS OF THE EMPLOYEES ALONG WITH ANNUAL SALARY IF THE EMPLOYEES ARE
EARING SOME SALARY BUT NOT A COMISSION.

4.WAQTD DIFFERENT SALARY PRESENT IN EMPLOYEE TABLE.

5.WAQTD ENAME ,SAL OF THE EMPLOYEES IF THE EMPLOYEES ARE HIRED DURING THE YEAR 81

AND EARNING SALARY IN THE RANGE OF 1250 TO 3000.

6.WAQTD DETAILS OF THE EMPLOYEES ALONG WITH ANNUAL SALARY WITH THE HIKE OF 10% IF THE
EMPLOYEE.

NAME HAS STARTS WITH 'J' AND ENDS WITH 'ES'

7.WAQTD NAME ,JOB ,DEPTNO OF THE EMPLOYEES IF THE EMPLOYEES ARE WORKING AS A
SALESMAN OR MANAGER IN DEPTNO 10 ,20 AND THE NAME HAS CHARACTER 'A' IN IT.

8.WAQTD JOB ,HIREDATE OF THE EMPLOYEES IF THE EMPLOYEES ARE HIRED AFTER 80 AND EARNING
SOME COMISSION.

9.WAQTD DETAILS OF THE EMPLOYEES WHO ARE EARNING SALARY LESS THAN 1500 AND GREATER
THAN 2500 (ONLY USE SPECIAL OPERATOR) .

10.WAQTD NAME OF THE EMPLOYEES NAME ENDS WITH CONSONENTS.

11.WAQTD DETAILS OF THE EMPLOYEES WHO ARE WORKING AS A MANAGER IN DEPTNO 10,20

12. WAQTD NAME ,DEPTNO ,JOB OF THE EMPLOYEES WHOSE NAME HAS A CHARACTER ‘A’ AND
WORKING IN DEPTNO 10

13. WAQTD DETAILS OF THE EMPLOYEES ALONG WITH ANNUAL SALARY IF THE EMPLOYEES WHOSE
NAME STARTS WITH ‘J’ AND ENDS WITH ‘S’

14.WAQTD NAMES OF THE EMPLOYEES WHOSE NAME HAS A CHARACTER ‘A’ OR ‘S’ WORKING AS
SALESMAN AND GETTING SOME COMMISSION .

15.WAQTD DIFFERENT HIREDATE PRESENT IN EMPLOYEE TABLE

16. WAQTD JOB ,HIREDATE OF THE EMPLOYEES IF THE EMPLOYEES ARE HIRED AFTER THE YEAR 81
AND HIRED IN THE MONTH OF DEC .

17.WAQTD EMPNO ,ENAME AND ANNUAL SALARY OF THE EMPLOYEES IF THE ANNUAL SALARY IS
GREATER THAN 14000 AND WORKING IN DEPTNO 10,20 AND GETTING SALARY IN THE RANGE OF
1000 TO 4000
KRISHNA_SQLQUES

18.WAQTD SALARY AND COMM OF THE EMPLOYEES IF THE EMPLOYEES ARE HIRED DURING THE
YEAR 82 AND THEIR ARE NOT GETTING ANY COMMISSION

19.WAQTD DETAILS OF THE EMPLOYEES ALONG WITH THE ANNUAL SALARIES HIKE OF 15%

20.WAQTD JOB ,SAL,HIREDATE OF THE EMPLOYEES IF THE EMPLOYEES ARE HIRED AFTER 81 BUT
BEFORE THE YEAR 88

21.WAQTD SAL,MGR,ENAME OF THE EMPLOYEES WHOSE SAL ENDS WITH ‘0’ WORKING AS A CLERK
OR A SALESMAN AND THE STARTS WITH THE CHARACTER ‘S’

22. WAQTD NAME ,JOB ,HIREDATE OF THE EMPLOYEES WHO ARE HIRED IN THE MONTH OF MAY
AND WORKING AS A MANAGER AND THEIR NAME HAS 5 CHARACTERS

23. WAQTD EMPNO ,COMM IF THE EMPLOYEES ARE GETTING COMMISSION AS 1400 AND THE
NAME STARTS WITH CHARACTER ‘M’ AND ENDS WITH A CHARACTER ‘S’ .

24. WAQTD SALARY WITH THE HIKE OF 10% ,ANNUAL SAL WITH THE HIKE OF 15%,AND SAL WITH
THE DEDUCTION OF 300 FOR ALL THE EMPLOYEES

25.WAQTD NAME AND JOB OF THE EMPLOYEES EXCEPT THE WHO ARE WORKING AS A SALESMAN OR
ANALYST.

You might also like