select sum(count(col1) -1) from emp group by col1 having count(col1) >

how do you count the duplicate records in a table

Question Posted / suresh a

Answer Posted / suresh a

select sum(count(col1) -1) from emp
group by col1 having count(col1) > 1

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sql rowcount?

987

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

963

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3556

what are the different type of normalization? : Sql dba

1011

What is output spooling in sql*plus?

1020

discuss about myisam key cache. : Sql dba

1004

How to change sql*plus system settings?

1041

How is use pl and sql?

1048

Are sql connections encrypted?

998

What is oracle sql developer?

1029

What is normalization in a database?

1142

What is a trigger word?

1001

How do I remove sql developer from windows 10?

1074

Where do we use pl sql?

982

How to process query result in pl/sql?

1103