Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete all duplicate records from a table using
subquery?
- 7 Answers
- 23451 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sunil
delete emp where empno not in(select distinct empno from emp);
For example we have duplicates in empno column then write
query like above...whatever column u want u can write..
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
How do I manually uninstall oracle client?
Where is the export dump file located?
How to create a new table in oracle?
What do you mean by redo log file mirroring?
What is the use of aggregate functions in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to update values on multiple rows in oracle?
What are the uses of linked server and explain it in detail?
Difference between hot backup vs. Cold backup?
How to invoke the data pump import utility?
How can windows applications connect to oracle servers?
Explain the use of ignore option in imp command.
defination of bitmap index
