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

Determine if oracle date is on a weekend?

1091

Explain the advantages and disadvantages of stored procedure?

1199

Why we use triggers in mysql?

1041

Explain the select statement in sql?

1185

What does the acronym acid stand for in database management?

1091

What do you understand by pl/sql packages?

1107

What are the basic sql commands?

1142

What is a join query?

1007

What are procedures used for?

1038

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2062

What are the constraints available in sql?

1088

What is null in pl/sql?

1121

Which join is like an inner join?

1095

How do I run a sql query in pgadmin 4?

1002

What are sql procedures?

1085