OpenText Interview Question
duplicate count from database
Interview Answer
Anonymous
Nov 17, 2020
SELECT col1, col2, COUNT(*) FROM tbl_name GROUP BY col1, col2 HAVING COUNT(*) > 1
2
duplicate count from database
Anonymous
SELECT col1, col2, COUNT(*) FROM tbl_name GROUP BY col1, col2 HAVING COUNT(*) > 1
Check out your Company Bowl for anonymous work chats.