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

What is loop in pl sql?

984

what is the difference between sql and t-sql? : Transact sql

1043

What are the most important ddl statements in sql?

1027

What is sqlerrd?

921

what are the differences between char and varchar? : Sql dba

1004

what is csv? : Sql dba

946

What is prepared statement in sql?

997

What is indexing in sql and its types?

1007

what is acid property in database? : Sql dba

962

what are all the common sql function? : Sql dba

1013

Can I join the same table twice?

996

how to increment dates by 1 in mysql? : Sql dba

927

describe transaction-safe table types in mysql : sql dba

945

how to enter binary numbers in sql statements? : Sql dba

923

What are local and global Indexes and where they are useful.

1379