[distinct ...]

[marketto]

SELECT DISTINCT * FROM tabella
WHERE campo2 != '' AND campo3 != '';