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 a primary key called that is made up of more than one field?

1333

What is the largest value that can be stored in a byte data field?

1002

Can we use delete in merge statement?

1031

What is difference between sql and oracle?

1100

What is the difference between instead of trigger and after trigger?

983

What are pl/sql packages?

1087

what is commit? : Sql dba

1063

Explain what is rdbms?

1021

Is it possible to create startup or shutdown trigger for on-schema?

1014

Explain the working of primary key?

1077

What is sql mysql pl sql oracle?

1059

What is delimiter in pl sql?

1041

What is bind reference and how can it be created?

1005

What are database links used for?

1031

How do you optimize a query?

980