SQL Exercise: Employees that work in department 47 or department 63
SQL Boolean Operator Statement: Exercise-12 with Solution
From the following table, write a SQL query to find the employees who work at depart 47 or 63. 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 47 or 63.
WHERE emp_dept = 47 OR emp_dept = 63;
Output of the Query:
emp_idno emp_fname emp_lname emp_dept 526689 Carlos Snares 63 328717 Jhon Snares 63 444527 Joseph Dosni 47 659831 Zanifer Emily 47 748681 Henrey Gabriel 47 733843 Mario Saule 63
Code Explanation:
The said SQL query that is selecting all columns (*) from the 'emp_details' table where the value of the "emp_dept" column is equal to 47 OR the value of the "emp_dept" column is equal to 63.
The query will return all rows from the 'emp_details' table that meet either of these conditions. It will return all the rows where the department of the employee is 47 or 63.
Relational Algebra Expression:
Relational Algebra Tree:
Practice Online
Query Visualization:
Duration:
Rows:
Cost:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous SQL Exercise: Find those employees whose last name is Dosni or Mardy.
Next SQL Exercise: SQL Wildcard and Special operators Exercises Home
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
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/sql-boolean-operator-exercise-12.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics