Find Employees With Same Joining Date

Find employees who joined on the same date.

sql

SELECT joined_at, GROUP_CONCAT(name) AS employees FROM employees GROUP BY joined_at HAVING COUNT(*) > 1;

This query groups the records in the "employees" table by the "joined_at" column and uses the HAVING clause to filter for dates associated with more than one employee, returning the list of names for each of those dates.

PromptDB can make mistakes. Please double-check responses.