devi usare group by

SELECT campo1,campo2,campo3 from Tabella group by campo1 order by campo1;

ciao
sergio