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

What are the benefits of triggers?

599

how to get a list of all tables in a database? : Sql dba

511

What is the use of count (*) in sql?

545

What is function and procedure in pl sql?

518

What is nvarchar max in sql?

579

What is a mutating table and a constraining table?

569

Why is sql*loader direct path so fast?

595

how to include numeric values in sql statements? : Sql dba

557

What are user defined functions?

577

What is trigger explain it?

549

explain what is mysql? : Sql dba

598

What is sql engine in oracle?

519

What is the difference between distinct and unique in sql?

472

what is data integrity? : Sql dba

594

What is pl sql and why it is used for?

572