Return non-repeated lines in a Select

Question

I am using the following select on oracle

select DISTINCT delivery, dt_coletado from table1

and is returned to the following line

 DELIVERY      DT_COLETADO
8816619995  2019-05-17 00:51:04
8816619995  2019-05-16 20:06:56

I want to know a way to return only the row that has the date of the column DT_COLETADO larger. That in the case is the row with the date of day 17-05-2019.

Answer 1

SELECT
    delivery, max(dt_coletado)AS dt_coletado
FROM table1
GROUP BY delivery