how do you count the duplicate records in a table
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 the difference between cluster and non cluster index? : Sql dba
Is oracle and sql same?
What is triggering circuit?
What is partition by in sql?
What are functions in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Explain constraints in sql?
how do you know the version of your mysql server? : Sql dba
What are analytical functions in sql?
Why do we use sql constraints?
How will you distinguish a global variable with a local variable in pl/sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is an implicit commit?
What is the difference between syntax error and runtime error?
what are local and global variables and their differences? : Sql dba