There are many way to count the duplicate row in a table select count(col

how do you count the duplicate records in a table

Question Posted / ajmal khan

Answer Posted / ajmal khan

There are many way to count the duplicate row in a table
select count(column_name)-count(distinct(column_name)) from
table_name;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to add a column ‘salary’ to a table employee_details?

953

Is record in oracle pl sql?

902

Name the different types of indexes in sql and define them.

1073

What are the uses of sysdate and user keywords?

1050

Why truncate is used in sql?

936

How do I count duplicates in sql?

1027

What is delimiter in pl sql?

987

What is percent sign in sql?

1213

How do you explain an index?

1222

how can we optimize or increase the speed of a mysql select query? : Sql dba

884

How many primary keys can a table have?

951

How many types of relationship are there?

973

What is an intersect?

1045

How many unique keys can a table have?

956

What is the function that is used to transfer a pl/sql table log to a database table?

950