select coloumn_name ,count(*) from table_name group by coloumn

how do you count the duplicate records in a table

Question Posted / priya

Answer Posted / priya

select coloumn_name ,count(*) from table_name
group by coloumn_name
having count(*) > 1;

Is This Answer Correct ?

35 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many triggers can be applied on a table?

923

What is synchronized subquery?

1144

Why select is used in sql?

1002

What is group by in sql?

1074

Which data type is a composite type?

974

Is pl sql still used?

961

What is pls_integer in pl sql?

1074

what are the different index configurations a table can have? : Sql dba

981

Is join an inner join?

948

What is sql catalog?

1000

How do you remove duplicates without using distinct in sql?

963

How can we make an if statement within a select statement?

998

What are records give examples?

991

What are types of indexes in sql?

1065

What is not equal in sql?

1088