For print duplicate entry from a table with their count see this query ->
select * FROM (SELECT ROW_NUMBER() OVER (PARTITION BY fname ORDER BY fname) cnt,* FROM USER_TABLE) duplicates WHERE duplicates.Cnt > 1
select * FROM
(SELECT ROW_NUMBER() OVER (PARTITION BY fname ORDER BY fname) cnt,*