Resolved: How to get Id as per the max date

    Id  WayBillNo       Date                       Status
------------------------------------------------------------------------------
    1   501263027308    2023-03-10 23:59:59.000    DELIVERED
    2   501263027308    2023-03-10 09:01:12.000    OUT FOR DELIVERY
    3   501263027308    2023-03-09 16:53:25.000    IN-TRANSIT
    4   501263027308    2023-03-09 03:40:37.000    IN-TRANSIT
    5   501263027308    2023-03-08 01:36:24.000    ARRIVED AT DESTINATI
    6   501263027308    2023-03-03 15:59:23.000    IN-TRANSIT
    7   501263027308    2023-03-01 20:50:38.000    IN-TRANSIT
    8   501263027312    2023-03-05 12:11:29.000    ARRIVED AT DESTINATI
    9   501263027312    2023-03-04 23:27:27.000    IN-TRANSIT
    10  501263027312    2023-03-03 19:11:06.000    IN-TRANSIT
    11  501263027312    2023-03-02 14:26:06.000    IN-TRANSIT
    12  501263027312    2023-03-01 20:50:38.000    IN-TRANSIT

Id
---
1   
8

select *
from tbl S
inner join (
    select WayBillNo,
        MaxDate=max([date])
    from tbl
    group by WayBillN
) T on T.WayBillNo=S.WayBillNo and T.MaxDate=S.Date