Pergunta de entrevista da empresa OpenText
duplicate count from database
Resposta da entrevista
Sigiloso
17 de nov. de 2020
SELECT col1, col2, COUNT(*) FROM tbl_name GROUP BY col1, col2 HAVING COUNT(*) > 1
2
duplicate count from database
Sigiloso
SELECT col1, col2, COUNT(*) FROM tbl_name GROUP BY col1, col2 HAVING COUNT(*) > 1