Oracle: List the name of all the employees who are working as accountant in finance section and drawing a salary is greater than equal to $5000 and less than equal to $20000

Oracle Operator: Exercise-7 with Solution

Write a query to list the name of all the employees who are working as accountant in finance section and drawing a salary is greater than equal to $5000 and less than equal to $20000.

Sample table : employees

Sample Solution:

Oracle Code:

SELECT  first_name, salary 
FROM  employees 
WHERE job_id='FI_ACCOUNT' and (salary>=5000 and salary<=20000);

Output:

FIRST_NAME               SALARY
-------------------- ----------
Daniel                     9000
John                       8200
Ismael                     7700
Jose Manuel                7800
Luis                       6900

Pictorial Presentation:

Improve this sample solution and post your code through Disqus.

Previous: Write a query to list the names of all the employees who are working as accountant in finance section and drawing a salary less than $20000.
Next: Write a query to list the names, salary of all the employees who are working with a commission package.