how to delete all duplicate records from a table using
subquery?
- 7 Answers
- 21929 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / aseem k
Tried and tested:
Table d:
7
8
7
DELETE FROM D WHERE ROWID IN (
SELECT DISTINCT MIN(ROWID) FROM D
WHERE DEPTNO IN
(SELECT DEPTNO FROM D GROUP BY DEPTNO
HAVING COUNT(DEPTNO)>1))
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain parameter file in oracle.
What do database buffers contain?
How to drop an existing table in oracle?
How to sort the query output in oracle?
How to run the anonymous block again?
What is bulk load in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How does one get the view definition of fixed views/tables?
What is recovery manager(rman) backup in Oracle?
What are dml statements in oracle?
What are the different types of partitions in oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is a read write transaction in oracle?
Explain about the analyze command in oracle?
How to use "while" statements in oracle?
