SELECT count(*), colonne1, colonne2 FROM matable GROUP BY colonne1, colonne2 HAVING count(*) > 1