how do you count the duplicate records in a table
- 10 Answers
- 17334 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How many postgresql users are there, worldwide?
Why plvtab is considered as the easiest way to access the pl/sql table?
explain advantages of innodb over myisam. : Sql dba
What are primary key and foreign key and how they work?
how can we destroy the cookie? : Sql dba
Explain the difference between drop and truncate commands in sql?
What is the use of pl/sql table?
Which are the different character-manipulation functions in sql?
How do you delete a table?
What is the difference between cluster and non-cluster index?
What is sql and its types?
How do you write a complex sql query?
Explain the working of primary key?
what are sequences
How delete all data from all tables in sql?
