delete from tablename where rowid not in(select min(rowid) from table nam

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Question Posted / veera

Answer Posted / veera

delete from tablename where rowid not in(select min(rowid)
from table name group by duplicate record col)

Is This Answer Correct ?

37 Yes

21 No

Please Help Members By Posting Answers For Below Questions

Explain oracle apps architecture.

1010

What do you understand by concurrent programs?

812

what are the prerequisites for costing transactions?

2885

In hierarchical structure of a database? we have write query from where we should start?

1936

What do you understand by a set of books?

843

Can you explain the difference between architecture followed in 10g & 11g?

866

what are the different transaction clauses in AR?

1842

What is count(*) from po_vendors(any table)?

835

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3347

How can we import the data into a database using sql * loader?

904

What are file in oracle.

2020

Explain what are the tables of auto invoice?

885

q)what are the validations in sql*loader

2039

What do you understand by soa and what are the benefits of using this architecture?

820

how can i print random rows in plsql table

2153