how to delete all duplicate records from a table using
subquery?
- 7 Answers
- 22609 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / maninder
delete from abc where rowid not in (select max(rowid) from
abc group by column_name_with_dup.values.);
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
What is integrity and what is constraint??Explain with example
How to convert raw data type into text in oracle? Explain
What are internal user account in oracle?
Explain the use of rows option in imp command.
What is null value in oracle?
Explain the use of indexes option in imp command.
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Explain an extent?
How to get the Installed Oracle Version Information ?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to rename an index?
Explain the use of inctype option in exp command.
What is a proxy object?
What do you understand by database schema and what does it hold?
How many anonymous blocks can be defined?
