where exists

サブクエリの結果が真のときにレコードが抽出される。

SELECT *
 FROM Absenteeism
 WHERE EXISTS
   (SELECT *
      FROM Absenteeism AS A2
     WHERE Absenteeism.emp_id = A2.emp_id
       AND Absenteeism.absent_date =
           (A2.absent_date + INTERVAL '1' DAY));