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: Find all the details of employees whose last name is Gabriel or Dosio

SQL SUBQUERY: Exercise-34 with Solution

34. From the following tables write a SQL query to find employees whose last name is Gabriel or Dosio. Return emp_idno, emp_fname, emp_lname and emp_dept.

Sample table: emp_details


Sample Solution: 

SELECT * 
  FROM emp_details
   WHERE emp_lname IN ('Gabriel' , 'Dosio');

Output of the Query:

emp_idno	emp_fname	emp_lname	emp_dept
843795		Enric		Dosio		57
748681		Henrey		Gabriel		47

Pictorial Presentation:

SQL Subqueries Inventory Exercises: Find all the details of employees whose last name is Gabriel or Dosio.

Practice Online


Sample Database:

Model Database

Query Visualization:

Duration:

Query visualization of Find all the details of employees whose last name is Gabriel or Dosio - Duration

Rows:

Query visualization of Find all the details of employees whose last name is Gabriel or Dosio - Rows

Cost:

Query visualization of Find all the details of employees whose last name is Gabriel or Dosio - Cost

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to find the most expensive product of each company. Return Product Name, Price and Company.
Next: 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.

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