how do you count the duplicate records in a table
- 10 Answers
- 17342 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
How many triggers can be applied on a table?
What is Materialized View? In What Scenario we Use Materialized View?
What is interval partition?
What is user in sql?
What are % type and % rowtype?
What is data control language (dcl)?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
what is log shipping? : Sql dba
How much ram can sql express use?
What is the purpose of cursors in pl/sql?
What are secondary keys?
Which data dictionary views have the information on the triggers that are available in the database?
Can we insert data into materialized view?
How do I view a view in sql?
What is substitution variable in pl sql?
