﻿ SQL SUBQUERIES: Find the employees who joined after the employee whose ID is 165 - w3resource

# SQL Subquery Exercises: Display the full name, email, and designation for all those employees who was hired after the employee whose ID is 165

## SQL SUBQUERY: Exercise-43 with Solution

From the following table, write a SQL query to find those employees who joined after the employee whose ID is 165. Return first name, last name and hire date.

Sample table: employees

Sample Solution:

``````SELECT first_name ||' '|| last_name AS Full_Name , hire_date
FROM employees
WHERE hire_date > (
SELECT hire_date
FROM employees
WHERE employee_id = 165);
``````

Sample Output:

```full_name	hire_date
Steven Markle	2008-03-08
Sundar Ande	2008-03-24
Amit Banda	2008-04-21
Sundita Kumar	2008-04-21
```

Pictorial Presentation:

## Query Visualization:

Duration:

Rows:

Cost:

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

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

﻿

## SQL: Tips of the Day

"where 1=1" statement?

It's usually when folks build up SQL statements.

When you add and value = "Toyota" you don't have to worry about whether there is a condition before or just WHERE.

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