searock
3/4/2016 - 6:39 AM
Search for duplicate values in a table.
Search for duplicate values in a table.
select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;
Search for duplicate values in a table.
select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;