SELECT C.num_cable, C.DATE, C.num_affaire, D.nom_client, C.num_commande, D.ref_cable, C.nom_cableur, COUNT(*) nb FROM commande_cable C, def_client D
WHERE D.id_def_client = C.id_def_client
AND C.nom_cableur = 'truc'
AND C.num_cable != 'ANNULE'
AND C.num_cable IS NOT NULL
GROUP BY C.num_cable
HAVING COUNT(*) > 1
ORDER BY C.DATE DESC