Find Most Recently Hired Employees Record

Find the most recently hired employee.

sql

SELECT * FROM employees ORDER BY hire_date DESC LIMIT 1;

This query selects all columns from the "employees" table, sorts the records by "hire_date" in descending order, and limits the result to the first row to identify the most recently hired employee.

PromptDB can make mistakes. Please double-check responses.