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

Does inner join return duplicate rows?

518

What is pivot query?

591

What is the location of pre_defined_functions.

644

Is json a nosql?

541

Which data type is a composite type?

528

What are the different dcl commands in sql?

559

What is the difference between stored procedure and view?

526

What is pragma in pl sql?

597

What is pl/sql table? Why it is used?

556

How do I run a query in pl sql developer?

560

Which language is used in sql?

516

What is nvarchar max in sql?

578

Write a query to find the names of users that begin with "um" in sql?

501

How do I kill a query in postgresql?

552

What is the process of debugging?

547