select emp_id,AsofDate,Comment FROM ( SELECT emp_id,AsofDate,Comment, lag(AsofDate) over(partition by emp_id order by AsofDate)prev_date, lag(AsofDate,2) over(partition by emp_id order by AsofDate)prev_pre_date from Employees_data where Comment = 'Absent') WHERE prev_date=AsofDate-1 and prev_pre_date = AsofDate-2;