Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

SQL Subquery Exercises: Display all the details of employees who works in department 89 or 63

SQL SUBQUERY: Exercise-35 with Solution

35. From the following tables, write a SQL query to find the employees who work in department 89 or 63. Return emp_idno, emp_fname, emp_lname and emp_dept.

Sample table: emp_department


Sample table: emp_details


Sample Solution: 

SELECT * 
  FROM emp_details
  WHERE emp_dept IN (89,63);

Output of the Query:

emp_idno	emp_fname	emp_lname	emp_dept
526689		Carlos		Snares		63
328717		Jhon		Snares		63
733843		Mario		Saule		63

Pictorial Presentation:

SQL Subqueries Inventory Exercises: Display all the details of employees who works in department 89 or 63.

Practice Online


Sample Database:

Model Database

Query Visualization:

Duration:

Query visualization of Display all the details of employees who works in department 89 or 63 - Duration

Rows:

Query visualization of Display all the details of employees who works in department 89 or 63 - Rows

Cost:

Query visualization of Display all the details of employees who works in department 89 or 63 - Cost

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to find those employees whose last name is 'Gabriel' or 'Dosio'. Return emp_idno, emp_fname, emp_lname and emp_dept.
Next: From the following tables, write a SQL query to find those employees who work for the department where the department allotment amount is more than Rs. 50000. Return emp_fname and emp_lname.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



SQL: Tips of the Day

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3