Forum Tranquil IT

Code : Tout sélectionner

SELECT count(hosts.computer_name) AS count_double,hosts.computer_name
from hosts
group by hosts.computer_name
having count(hosts.computer_name) > 1

Code : Tout sélectionner

SELECT h.uuid, h.computer_name
FROM hosts h
JOIN (
    SELECT computer_name
    FROM hosts
    GROUP BY computer_name
    HAVING COUNT(computer_name) > 1
) dup ON h.computer_name = dup.computer_name
ORDER BY h.uuid;