select column,count(1) from a group by column having count(1)>1;

how do you count the duplicate records in a table

Question Posted / purushotham

Answer Posted / purushotham

select column,count(1) from a
group by column
having count(1)>1;

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I remove sql developer from windows 10?

1185

how to use 'mysql' to run sql statements? : Sql dba

1123

What are the different ways to optimize a sql query?

990

What is the most common sql injection tool?

1091

What is multiple partition?

1019

Does view contain data?

1084

What are the most important ddl statements in sql?

1190

when is the use of update_statistics command? : Sql dba

1099

What is primary key and unique key?

1167

How to load data with sql*loader?

1112

what is meant by urlencode and urldocode? : Sql dba

1242

What is execute immediate?

1164

How do you update a sql procedure?

1092

Can a primary key be a foreign key?

1081

Which nosql database is best?

1025