HI Everyone,
it would be great if you suggest on below-
i have below data
| Emp id | date | flag |
| 1 | 01-01-2020 | Y |
| 2 | 01-01-2020 | N |
| 3 | 01-01-2020 | Y |
| 4 | 01-01-2020 | Y |
| 5 | 01-01-2020 | Y |
| 1 | 15-01-2020 | N |
| 2 | 16-01-2020 | Y |
| 3 | 20-01-2020 | N |
flag value says yes or no for employee who is coming for event. (if employee is coming for event then flag yes else no)
date is updated entry for employee if employee changes mind for attending event.
i want final list of employee who are coming for event.
