Find Duplicate Entries Of A Particular Column In A Table
SELECT col1, COUNT(col1) AS NumOccurrences FROM table1 GROUP BY col1 HAVING (COUNT(col1) > 1)
Replace col1 with your column name and
table 1 with your table name
Recent Posts
SELECT col1, COUNT(col1) AS NumOccurrences FROM table1 GROUP BY col1 HAVING (COUNT(col1) > 1)
Replace col1 with your column name and
table 1 with your table name
Recent Comments