Interested to Buy Any Domain ? << Click Here >> for more details...
how do you count the duplicate records in a table
- 10 Answers
- 18913 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / dev
Hi,
There are many ways to do it.
One of that is ,
select count(0) from tab1 a
where a.rowid > any (select b.rowid from tab1 b where
a.col1 =b.col1);
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is character functions?
What is pl/sql table? Why it is used?
What is a unique constraint?
How can you select unique records from a table?
Explain the uses of control file.
What is relationship? How many types of relationship are there?
What is difference between procedure and trigger?
What does joining a thread mean?
What is an escape character in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
How you improve the performance of sql*loader? : aql loader
What is the life of an sql statement?
Why plvtab is considered as the easiest way to access the pl/sql table?
How many types of triggers are there in pl sql?
What is secondary key?
