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 denormalization. : Sql dba

1162

Does sql require a server?

1056

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1057

Can you inner join the same table?

1039

Is a secondary key the same as a foreign key?

1120

Are there any features that are decommissioned in 11g that are not present in 11g?

2197

What is trigger and stored procedure in sql?

1094

What do you understand by pl/sql packages?

1107

Explain unique key in sql.

1063

What is sql partition?

1168

Is primary key a clustered index?

1014

What do you understand by exception handling in pl/sql?

1089

How show all rows in sql?

1060

How do you delete data from a table?

1104

Can triggers stop a dml statement from executing on a table?

1160