Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete all duplicate records from a table using
subquery?
- 7 Answers
- 23961 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / noor
DELETE FROM T1
WHERE ROWID IN (SELECT ROWID FROM T1
WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM
T1 GROUP BY C1,C2));
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is connection pooling in oracle?
What language does oracle use?
What is the data pump export utility?
How to define an external table with a text file?
How to use attributes of the implicit cursor in oracle?
What is the difference between a hot backup and a cold backup in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to write date and time literals in oracle?
What are the different oracle database objects?
What is background process in Oracle?
Give the different types of rollback segments.
Difference between inner join vs where ?
Explain integrity constraints?
How to define an explicit cursor in oracle?
How to manage transaction isolation level?
