w3resource

SQL Exercise: List all the employees whose designation is CLERK

SQL employee Database: Exercise-20 with Solution

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

20. From the following table, write a SQL query to find those employees whose designation is ‘CLERK’. Return complete information about the employees.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: List all the employees whose designation is CLERK

Sample Solution:

SELECT *
FROM employees
WHERE job_name = 'CLERK';

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
  69000 | JULIUS   | CLERK    |      66928 | 1991-12-03 | 1050.00 |            |   3001
  69324 | MARKER   | CLERK    |      67832 | 1992-01-23 | 1400.00 |            |   1001
(4 rows)

Explanation:

The provided query in SQL that retrieves all the rows from the 'employees' table where the "job_name" column has a value of 'CLERK'.

The result will include all columns of the selected rows.

Relational Algebra Expression:

Relational Algebra Expression: List all the employees whose designation is CLERK.

Relational Algebra Tree:

Relational Algebra Tree:List all the employees whose designation is CLERK.

Practice Online


Sample Database: employee

employee database structure

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

Previous SQL Exercise: Employees and managers name separated by a string.
Next SQL Exercise: Employees with more than 27 years of experience.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/sql-exercises/employee-database-exercise/sql-employee-database-exercise-20.php