Find Earliest Hired Employee in Employees

Find the earliest hired employee.

sql

SELECT * FROM employees ORDER BY hire_date ASC LIMIT 1;

This query selects all columns from the "employees" table, sorts the records by the "hire_date" column in ascending order, and limits the result to the first record to identify the earliest hired employee.

PromptDB can make mistakes. Please double-check responses.