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

Perfect Attendance

Return the ids of employees who attended on every distinct date present in the table, ordered by id.

Table schema

Attendance(emp_id INT, check_in DATETIME, check_out DATETIME)

Sample data

emp_id | check_in | check_out
1 | 2026-09-01 09:00:00 | 2026-09-01 17:30:00
2 | 2026-09-01 09:20:00 | 2026-09-01 18:00:00
1 | 2026-09-02 09:05:00 | 2026-09-02 19:05:00
3 | 2026-09-02 08:55:00 | 2026-09-02 16:55:00
2 | 2026-09-02 09:00:00 | 2026-09-02 17:00:00

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.