Questions on Basic SELECT statement:
2. List the employees name having letter 'L' as the second character
3. List the employees name having 'E' as last but one character
4. List the employees name having exactly 4 letters
5. List the employee whose name is having letter 'L'
6. List the employees name having atleast 5 characters
7. List employees earning between 2000 and 3000
9. List emp who do not have any reporting manager or commision is Null
10. List emp who do not have any reporting manager AND commision is Null
11. List only managers
12. List managers working in dept 10 and 20
13. List all the clerks and analysts with salary atleast 1000 in dept 20 and 30
14. List the employees in dept 20 and 30 who get no commision
15. List employees whose name starts with either 'A' or 'S' in dept 20
16. List all the employee whoe name does not end with 'S' in dept 20 and 30
17. List the employees who are getting some commision with sal > 1500 in dept 30
18. List the employees who are getting some commision with sal>1500 in dept 30
19. List emp working as managers and clerks with Salary atleast 2000 except in dept 10 and 20
20. List emp who get commmision
21. List employees in all dept whose salary not in the range of 2000 to 3000 with the job which is having a string called 'MAN'
Syntax:
SELECT *|{[DISTINCT] column|expression [alias],...}
FROM table
[WHERE condition(s)];
1. Display all the employees whose name starts with 'S'
3. List the employees name having 'E' as last but one character
4. List the employees name having exactly 4 letters
5. List the employee whose name is having letter 'L'
6. List the employees name having atleast 5 characters
7. List employees earning between 2000 and 3000
9. List emp who do not have any reporting manager or commision is Null
10. List emp who do not have any reporting manager AND commision is Null
11. List only managers
12. List managers working in dept 10 and 20
13. List all the clerks and analysts with salary atleast 1000 in dept 20 and 30
14. List the employees in dept 20 and 30 who get no commision
15. List employees whose name starts with either 'A' or 'S' in dept 20
16. List all the employee whoe name does not end with 'S' in dept 20 and 30
17. List the employees who are getting some commision with sal > 1500 in dept 30
18. List the employees who are getting some commision with sal>1500 in dept 30
19. List emp working as managers and clerks with Salary atleast 2000 except in dept 10 and 20
20. List emp who get commmision
21. List employees in all dept whose salary not in the range of 2000 to 3000 with the job which is having a string called 'MAN'
Comments