Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Employees Sharing a Birthday

Return pairs of different employees (smaller id first) who share the same month and day of birth. Order by the pair.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(10), birth_date DATE)

Sample data

id | name | birth_date
1 | Ann | 1990-03-05
2 | Bob | 1985-03-05
3 | Cy | 1992-07-21
4 | Dee | 2000-03-05
5 | Eli | 1991-07-22

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.