Operator

Showing 1–20 of 24 problems

1. 01Show those employees details whose first name starts with the letter s→
2. 02Show those employees details whose first name doesn’t starts with the letter s→
3. 03Show those employees details whose first name ends with the letter a→
4. 04Show those employees details whose first name contains the letter d→
5. 05Show those employees details whose first name contains da as substring→
6. 06Show those employees details whose first name starts with s and ends with a→
7. 07Show those employees details whose first name either starts with s or starts with m→
8. 08Show those employees details whose first name contains the letter o and a→
9. 09Show those employees details whose first name contains a letter o followed by a letter a→
10. 10Show those employees details whose first name consists of exactly 3 chars→
11. 11 Show those employees details whose first name consists of minimum 3 characters→
12. 12Show those employees details whose first name contains the letter a from the second last position→
13. 13Show those countries details whose country_id is AU or BR or CN or JP→
14. 14Show those departments details whose manager_id is not 204 or 100 or 145→
15. 15Show those employees details whose job_id is ST_MAN or IT_PROG→
16. 16Show those employees details who is not assigned to the department_id 100 or 30 or 90→
17. 17Show those locations details whose postal_code is either 2901 or 50090→
18. 18Show those locations details where the city is either Roma/Venice/Tokyo→
19. 19Show those departments details whose location_id is within the range 1000 to 2000 inclusive→
20. 20Show those employees details whose salary is within the range 10000 to 20000 inclusive→