SELECT nombre_cliente,count(*)
FROM clientes
GROUP BY nombre_cliente
HAVING COUNT(*)>1