I have a big dataset and which contain id's and daily values for it for a few years. I want to select for each id's the maximum day for each month for this few years. ID DATE 2 01JAN202 2 02JAN2020 2 03JAN2020 2 22FEB2020 2 24FEB2020 3 01JAN2020 3 02JAN2020 3 22FEB2020 3 24FEB2020 4 01JAN2020 4 02JAN2020 4 22FEB2021 4 23FEB2021 4 25MAR2021 4 26MAR2021 4 27MAR2021 For the above sample I need to get the data as below: 2 02JAN2020 2 24FEB2020 3 02JAN2020 3 24FEB2020 4 02JAN2020 4 23FEB2021 4 27MAR2021
... View more