Aryan PrajapatKnowledge Contributor
Write a select query that will be displayed the duplicated site name and how many times it is duplicated?
Write a select query that will be displayed the duplicated site name and how many times it is duplicated?
SELECT Sitename, COUNT(*) AS NumOccurrences FROM tbl_sites GROUP BY Sitename HAVING COUNT(*) > 1