Interested to Buy Any Domain ? << Click Here >> for more details...
how do you count the duplicate records in a table
- 10 Answers
- 19170 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 the sql query to display the current date?
What is vector point function?
Why do you partition data?
How much does sql certification cost?
How do you bind variables in pl sql?
How many scalar data types are supported in pl/sql?
Explain the structure of pl/sql in brief.
How do you get column names only for a table (sql server)?
Is big data nosql?
What are the different set operators available in sql?
What are the advantages of indexing?
What are sql indexes?
What is a sql driver?
What is a temporal data type?
What is the meaning of disabling a trigger?
