SQL Exercises: List the employees that work in the department 57

Last update on February 10 2025 06:29:09 (UTC/GMT +8 hours)

From the following table, write a SQL query to retrieve the details of the employees who work in the department 57. Return emp_idno, emp_fname, emp_lname and emp_dept.

Sample table: emp_details

 EMP_IDNO EMP_FNAME       EMP_LNAME         EMP_DEPT
--------- --------------- --------------- ----------
   127323 Michale         Robbin                  57
   526689 Carlos          Snares                  63
   843795 Enric           Dosio                   57
   328717 Jhon            Snares                  63
   444527 Joseph          Dosni                   47
   659831 Zanifer         Emily                   47
   847674 Kuleswar        Sitaraman               57
   748681 Henrey          Gabriel                 47
   555935 Alex            Manuel                  57
   539569 George          Mardy                   27
   733843 Mario           Saule                   63
   631548 Alan            Snappy                  27
   839139 Maria           Foster                  57

Sample Solution:

-- This query selects all columns from the 'emp_details' table.
SELECT *
-- Specifies the table from which to retrieve the data (in this case, 'emp_details').
FROM emp_details
-- Filters the rows to only include those where the 'emp_dept' column has the value 57.
WHERE emp_dept = 57;

Output of the Query:

emp_idno	emp_fname	emp_lname	emp_dept
839139		Maria		Foster		57
127323		Michale		Robbin		57
843795		Enric		Dosio		57
847674		Kuleswar	Sitaraman	57
555935		Alex		Manuel		57

Code Explanation:

This SQL statement selects all columns from the table named 'emp_details' where the emp_dept is 57. It returns all the rows that have the value 57 in the emp_dept column.

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

For more Practice: Solve these Related Problems:

Write a SQL query to find employees working in department 63 and return their full details.
Write a SQL query to retrieve employees assigned to department 47, displaying their IDs, names, and departments.
Write a SQL query to list all employees in department 27, ordered by their last names in ascending order.
Write a SQL query to count the number of employees in department 57 and display the result.

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

Previous SQL Exercises: Find the data of employees whose last name is 'Snares'.
Next SQL Exercise: SQL Boolean and Relational Operators Exercises Home