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

How to check if a column is nullable before setting to nullable?

580

What are the types of keys?

510

How can we avoid duplicating records in a query?

562

What is the use of double ampersand (&&) in sql queries? Give an example

609

What is pl sql in oracle?

579

Explain the difference between sql and mysql.

565

Can function return multiple values in sql?

524

how to use myisamchk to check or repair myisam tables? : Sql dba

505

Is sql database free?

525

How would you pass hints to the sql processor?

525

discuss about myisam index statistics collection. : Sql dba

523

What are the different sql languages?

538

Why select is used in sql?

514

What is sql analyzer?

539

What is the non-clustered index in sql?

587