Jun 25, 2020 07:31 AM|yij sun|LINK
Accroding to your description,as far as I think,you could orderby col2.
More details,you could refer to below codes:
AS (SELECT *,
partition by Col1 order by Col2 desc) AS rn
) --Omit date entries
WHERE rn = 2
More details,you could refer to below article: