SELECT DISTINCT categorie, oppure

SELECT * FROM TABELLA
GROUP BY CATEGORIE