how do you count the duplicate records in a table
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
Does pdo prevent sql injection?
what is a constraint? Tell me about its various levels. : Sql dba
What are sql functions? Describe in brief different types of sql functions?
What is rtm stands for?
what is meant by urlencode and urldocode? : Sql dba
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is a natural join sql?
What is rownum?
Explain the difference between triggers and constraints?
How do I create an index in word?
What is output spooling in sql*plus?
What is sql entity?
Does varchar need length?
How many types of primary keys are there?
What is union?