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 sqlite format?
Which nosql database is best?
What has stored procedures in sql and how we can use it?
what are sequences
What is partition by in sql?
What does rownum mean in sql?
What are all different types of collation sensitivity?
Why do we use joins in sql?
Is pl sql better than sql?
Which is faster view or stored procedure?
what are different types of collation sensitivity? : Sql dba
What are the two types of periodical indexes?
What is exception? What are the types of exceptions?
Why is a primary key important?
Describe sql comments?