select count(*) from table_name group by column1,column2... having count(

how do you count the duplicate records in a table

Question Posted / shalu

Answer Posted / shalu

select count(*) from table_name group by column1,column2...
having count(*) > 1

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

728

What is memory optimized table?

764

What packages are available to pl/sql developers?

811

Is clustered index a primary key?

692

Which is better cte or subquery?

714

What is a sql profiler?

770

what is isam? : Sql dba

768

What is the use of %rowtype?

747

What are the types of subqueries?

769

Is left join faster than join?

762

Is pl sql different from sql?

717

How to run sql functions in pl/sql?

725

What is restrict in sql?

743

How many types of relationship are there?

737

How do I run sql profiler?

765