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

How can you save or place your msg in a table?

711

Name some usages of database trigger?

748

Are stored procedures faster than dynamic sql?

738

What is the most important ddl statements in sql are?

727

Sql technical questions

1002

Is drop table faster than truncate?

740

How to create a menu in sqlplus or pl/sql?

809

which tcp/ip port does sql server run on? : Sql dba

706

what is an extent ? : Sql dba

751

explain what is mysql? : Sql dba

787

How do I pipe the output of one isql to another?

722

What are the types of sql commands?

745

how to enter numeric values as hex numbers? : Sql dba

770

What is sql*plus?

775

What is structural independence and why is it important?

758