github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/migration/v2_to_v3/cmd/remove_dup_doc/select_doublons.sql (about) 1 SELECT 2 cd1.id_document, 3 documents.nom_client, 4 documents.description 5 FROM 6 contenu_documents cd1 7 JOIN documents ON documents.id = cd1.id_document 8 WHERE 9 ( 10 SELECT 11 count(*) 12 FROM 13 contenu_documents cd2 14 WHERE 15 cd2.contenu = cd1.contenu 16 ) > 1 17 AND id_document IN ( 18 SELECT 19 id_document 20 FROM 21 document_personnes 22 ) 23 ORDER BY 24 contenu;