Query Employees by Hire Date Range

Find employees who joined between two given dates.

sql

SELECT id, name, hire_date FROM employees WHERE hire_date BETWEEN '2023-01-01' AND '2023-12-31';

This query selects the "id", "name", and "hire_date" columns from the "employees" table for all records where the "hire_date" falls within the specified inclusive range.

PromptDB can make mistakes. Please double-check responses.