w3resource
SQL exercises

SQL exercises on employee Database: List all the employees of designation CLERK in department no 2001

SQL employee Database: Exercise-38 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

38. Write a query in SQL to list all the employees of designation CLERK in department no 2001.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: List all the employees of designation CLERK in department no 2001

Sample Solution:

SELECT *
FROM employees
WHERE job_name ='CLERK'
  AND dep_id = 2001;

Sample Output:

 emp_id | emp_name | job_name | manager_id | hire_date  | salary  | commission | dep_id
--------+----------+----------+------------+------------+---------+------------+--------
  63679 | SANDRINE | CLERK    |      69062 | 1990-12-18 |  900.00 |            |   2001
  68736 | ADNRES   | CLERK    |      67858 | 1997-05-23 | 1200.00 |            |   2001
(2 rows)

Practice Online


Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query in SQL to list the employees who are working for the department ID 1001 or 2001.
Next: Write a query in SQL to list the ID, name, salary, and job_name of the employees for - 1. Annual salary is below 34000 but receiving some commission which should not be more than the salary, 2. And designation is SALESMAN and working for department 3001.

What is the difficulty level of this exercise?