I want to exclude those records which are most recent based on created date in the below table. For reference for id 40 and 50, date of 4/25 and 4/28 has been excluded from the output which are recent for that id
Input
id | Created Date |
40 | 4/24/2024 |
40 | 4/25/2024 |
50 | 4/26/2024 |
50 | 4/28/2024 |
Output
id | Created Date |
40 | 4/24/2024 |
50 | 4/26/2024 |
