how to delete all duplicate records from a table using
subquery?
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
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is a database schema in oracle?
Explain the difference between sap and oracle?
What are the numeric comparison operations?
What are operators in oracle?
How to assign data of the deleted row to variables?
How does Oracle guarantee data integrity of data changes?
How to convert csv to table in oracle?
How to turn on or off recycle bin for the session?
Can we create database in oracle using command line ?
What is an oracle database table?
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.
How to load data from external tables to regular tables?
various types of hints and their usage
How to define an anonymous procedure with variables?