Select DISTINCT returning too many records...

how to get biggest result from a sql result in postgresql...