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

Last update on October 24 2025 11:31:35 (UTC/GMT +8 hours)

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:

Go to:

PREV : 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.

Improve this sample solution and post your code through Disqus.