Select most recent record from a given table - Postgresql

Question

I need to select the most recent record of my Estoque case the column data be different, I managed as follows to bring the oldest when the dates are different:

SELECT codigosuprimento, numeroserie, max(data)
FROM public.estoque where usado = '1' and numeroserie = '1201607048733' 
group by codigosuprimento, numeroserie;

But when the column data is the same I want him to bring all the records that the dates are the same, for example:

I’d bring you both lines since the dates are the same, but when it is so:

Would bring the date 2017-08-18 for being the most current.

Answer 1

A solution can be a subselect with MAX

SELECT codigosuprimento, numeroserie, data
FROM public.estoque p1----faz uma primeira instancia da tabela 
where usado = '1' 
and numeroserie = '1201607048733' 
-- este subselect procura a maior data da mesma chave do registro
and data = (SELECT max(data)
            --faz uma segunda instancia da tabela 
            --renomeia o "alaias" para diferenciar
            FROM public.estoque p2
            where p2.usado       = p1.usado
            and   p2.numeroserie = p1.numeroserie)