Oracle: List the name of all the employees who are working in department number 20

Oracle Operator: Exercise-1 with Solution

Write a query to list the name of all the employees who are working in department number 20.

Sample table: employees

Sample Solution :-

Oracle Code :

SELECT first_name, last_name, department_id 
FROM employees 
WHERE department_id =20;

Output:

FIRST_NAME           LAST_NAME                 DEPARTMENT_ID
-------------------- ------------------------- -------------
Michael              Hartstein                            20
Pat                  Fay                                  20

Pictorial Presentation:

Improve this sample solution and post your code through Disqus.

Previous: Oracle Operator
Next: Write a query to list the employees name and total salary of a year and yearly salary is more than $10000.