postgreSQL DISTINCT Vs Group By

[-AA-]

Una cosa tipo

"SELECT * FROM tabella WHERE campo1 = '$campo1' AND campo2 = '$campo2' AND campo3 = '$campo3' AND campo4
IN(select * from tabella group by campo4)"