Fetching Details of the Most Recently Hired Employee from Northwind Database
Easy
8
90.6% Acceptance
In this lab, you'll be working with the database, specifically focusing on the employees
table. Your task is to write an SQL query to fetch details about the most recently hired employee.
Objective
Your SQL query should return the first_name
, last_name
, and hire_date
of the employee who was hired most recently.
Schema
Schema of the employees
table for reference
employee_id
last_name
first_name
title
title_of_courtesy
birth_date
hire_date
address
city
region
postal_code
country
home_phone
extension
reports_to
Concepts
SELECT
: To choose the columns you want to display.MAX
: To find the highest value in a numeric field.
The final column names must be first_name
, last_name
, and hire_date
Good luck!