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 count records in sql?

1054

What is the use of index in sql?

1068

What is right join in sql?

1158

What is the meaning of disabling a trigger?

1242

How does sql developer connect to oracle database?

1051

Which query operators in sql is used for pattern matching?

1012

Why is the cursor important?

1082

What are the different schemas objects that can be created using pl/sql?

1085

What is transaction control language (tcl)?

1187

What is pl sql block in dbms?

1055

explain access control lists. : Sql dba

1050

What are the different types of triggers?

1194

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7496

Can a foreign key have a different name?

998

What is the left table in sql?

1015