SELECT DISTINCT

select DISTINCT on (automatico) automatico,* from lancamento where empresa=85 order by automatico