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 does pl sql stand for?

653

What is the most common sql injection tool?

543

How to run sql functions in pl/sql?

534

What is case function?

596

What is group by in sql?

546

What is a scalar value in sql?

580

Is join and inner join the same?

537

What is sqlerrd?

524

What are the advantages of sql? Explain

648

Is inner join faster than left join?

629

Can we join same table in sql?

523

What is the difference between rollback and rollback to statements?

581

What are the steps for performance tuning.

838

How do I save a sql query?

542

how to drop an existing view in mysql? : Sql dba

566