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 a sql driver?
How do I delete a trigger?
Is mariadb a nosql database?
Why join is faster than subquery?
Is coalesce faster than isnull?
What is bind variable in pl sql?
what is sp_pkeys? : Transact sql
Does a user_objects view have an entry for a trigger?
What is using in sql?
What is pl sql script?
How to process query result in pl/sql?
Which one is better sql or oracle?
What do we need to check in database testing?
what is innodb? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?