Check Duplicate Data on a Table Column

 
Script used for checking duplicate data on a Table Column

— No need to format column values
— replace column_name with the desired column
— replace table_name with the desired table
— Only works on single columns
select column_name, count(column_name)
from table_name
group by column_name
having count (column_name) > 1;

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

About Jimbart