how do you count the duplicate records in a table
- 10 Answers
- 17328 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / satheesh
SELECT COUNT(*)
FROM TABLE A
WHERE ROWID NOT IN (SELECT MAX(ROWID)
FROM TABLE B
WHERE A.COL1 = B.COL1);--UNIQUE COLUMN
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a temp table?
How many times can we commit in a loop?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How many types of normalization are there?
What is the least restrictive isolation level? : Transact sql
What are local and global Indexes and where they are useful.
How do you create an update query?
Explain the purpose of %type and %rowtype data types?
How do I edit a trigger in sql developer?
What is foreign key and example?
Can we insert data in view?
How many tables can you join in sql?
What are synonyms in sql?
what is the command line end user interface - mysql? : Sql dba
How to make a copy values from one column to another in sql?
