MySQL / Operator
- Show those employees details whose first name starts with the letter s
- Show those employees details whose first name doesn’t starts with the letter s
- Show those employees details whose first name ends with the letter a
- Show those employees details whose first name contains the letter d
- Show those employees details whose first name contains da as substring
- Show those employees details whose first name starts with s and ends with a
- Show those employees details whose first name either starts with s or starts with m
- Show those employees details whose first name contains the letter o and a
- Show those employees details whose first name contains a letter o followed by a letter a
- Show those employees details whose first name consists of exactly 3 chars
- Show those employees details whose first name consists of minimum 3 characters
- Show those employees details whose first name contains the letter a from the second last position
- Show those countries details whose country_id is AU or BR or CN or JP
- Show those departments details whose manager_id is not 204 or 100 or 145
- Show those employees details whose job_id is ST_MAN or IT_PROG
- Show those employees details who is not assigned to the department_id 100 or 30 or 90
- Show those locations details whose postal_code is either 2901 or 50090
- Show those locations details where the city is either Roma/Venice/Tokyo
- Show those departments details whose location_id is within the range 1000 to 2000 inclusive
- Show those employees details whose salary is within the range 10000 to 20000 inclusive
- Show those employees details whose hire_date is within the range 1987-01-01 to 1987-06-30 inclusive
- Show those jobs details where the difference between max_salary and min _salary is within the range 5000 to 10000 inclusive
- Show those job_history details where the end_date is within 1998-12-01 to 1998-12-31 inclusive
- Show those employees details whose department_id is within the range 50 to 60 inclusive