finding out redundancy

I have a foreign table...and I wanna see the redundant 开发者_高级运维rows corresponding to the foreign column and also the number of redundancy.

select foriegn_column_name,COUNT(foriegn_column_name) from table_name
group by foriegn_column_name
having COUNT(foriegn_column_name) > 1