I have multiple ID's with multiple status change over multiple days. There are some Id's with 2-3 status recorded in one day, I want all the ID's and their status at EOD
Eg: I want ID A and its EOD value on 09/09/20 (status Y in this case) plus I want ID A on 09/15/20 and its status
ID | date_Time | Status| A 09/09/20 9 am X A 09/09/20 5 pm Y A 09/15/20 3 pm X B 09/09/20 9 am X B 09/09/20 5 pm Y