>SELECT cNom,cnosecretaraitSocial,COUNT(cnosecretaraitSocial) FROM Employee GROUP BY cNom

Thank jon but your query give :

> *-- Cnom Clé nombre
Tartanpion , 0023 , 1
Tartanpiop , 0024 , 1 &&& here the key is not unique
FarDDDD , 0024 , 1 &&& here the key is not unique

AND NOT

> *-- Cnom Clé nombre
> Tartanpion , 0023 , 1
> Tartanpiop , 0024 , 2 &&& here the key is not unique
> FarDDDD , 0024 , 2 &&& here the key is not unique



bernhart