"clients" id client_id name 1 200001 dupond 4 200001 dupond 7 200004 gerard 6 200004 gerard 9 200004 gerard 5 200006 dupontel ' 1/ find values that have duplicates : ' SELECT client_id, name FROM customers GROUP BY client_id, name HAVING COUNT(*) > 1; id client_id name 1 200001 dupond 7 200004 gerard ' 2/ find values that are duplicates ' SELECT id, client_id, name FROM customers QUALIFY ROW_NUMBER() OVER (PARTITION BY clinet_id, name ORDER BY client_id) > 1; id client_id name 4 200001 dupond 6 200004 gerard 9 200004 gerard