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

Can a table have no primary key?

1041

What is full join in sql?

977

What is difference between stored function and application function?

1178

Explian rowid, rownum? What are the psoducolumns we have?

989

What is sql data?

976

Can we use commit inside a trigger?

1071

Is pl sql a scripting language?

1017

Is left join faster than inner join?

1109

how to shutdown mysql server? : Sql dba

1084

What is the difference among union, minus and intersect?

986

Can we debug stored procedure?

1013

What does where 1 1 mean in sql?

1022

Why do we use procedures in sql?

1062

How do you update sql?

956

Does truncate release storage space?

1063