Question d’entretien chez OpenText
duplicate count from database
Réponse à la question d'entretien
Utilisateur anonyme
17 nov. 2020
SELECT col1, col2, COUNT(*) FROM tbl_name GROUP BY col1, col2 HAVING COUNT(*) > 1
2
duplicate count from database
Utilisateur anonyme
SELECT col1, col2, COUNT(*) FROM tbl_name GROUP BY col1, col2 HAVING COUNT(*) > 1