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 |
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.