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 do you update sql?

991

How do I partition in sql?

968

How to move files from one directory to another in pl sql?

1196

What are the sql commands?

1187

What is primary key and foreign key?

965

What are sql functions? Describe in brief different types of sql functions?

1105

What is sql mysql pl sql oracle?

1075

How to find 3rd highest salary of an employee from the employee table in sql?

1083

What are the sql versions?

961

What is the difference between microsoft sql and mysql?

967

How many triggers can be applied on a table?

935

Is not null in sql?

1000

What is union, minus and interact commands?

1301

What are all the different normalizations?

1038

What is using in sql?

1098