w3resource

Oracle: List the name of all the employees who are working as account manager and drawing a salary more than $5000

Oracle Operator: Exercise-5 with Solution

Write a query to list the name of all the employees who are working as account manager and drawing a salary more than $5000.

Sample table: employees


Sample Solution :-

Oracle Code :

SELECT  first_name, salary 
FROM  employees 
WHERE job_id='AC_MGR' and salary>5000;

Output:

FIRST_NAME               SALARY
-------------------- ----------
Shelley                   12008

Pictorial Presentation:

Pictorial: List the name of all the employees who are working as account manager and drawing a salary more than $5000

Improve this sample solution and post your code through Disqus.

Previous: Write a query to list the name of all the employees who are not working in department number 20.
Next: 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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.