Employees With Perfect Attendance

Return the emp_ids of employees who were present on every distinct working day in the table. Order by emp_id.

Table schema

Attendance(emp_id INT, day DATE, present INT)

Sample data

emp_id | day | present
1 | 2026-10-01 | 1
1 | 2026-10-02 | 1
1 | 2026-10-03 | 1
2 | 2026-10-01 | 1
2 | 2026-10-02 | 0
2 | 2026-10-03 | 1