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 do I partition in sql?

968

What is cold data?

966

What do you understand by pl/sql cursors?

1092

Can we use ddl statements in stored procedure sql server?

1015

How can we store rows in PL/SQL using array?

1226

What is full join in sql?

999

What is sql profiler in oracle?

1099

Is microsoft sql free?

1107

What are packages in pl sql and also explain its advantages?

1043

How do I install sql?

1002

How many postgresql users are there, worldwide?

1068

How do you bind variables in pl sql?

1104

What is a sql trace file?

1034

What does subquery mean in sql?

1058

What schema means?

893