Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete all duplicate records from a table using
subquery?
- 7 Answers
- 23978 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / noor
DELETE FROM T1
WHERE ROWID IN (SELECT ROWID FROM T1
WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM
T1 GROUP BY C1,C2));
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain about integrity constraint?
What to do if the binary spfile is wrong for the default instance?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is oracle open database communication (odbc)?
what are actual and formal parameters?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is merge in oracle?
How to invoke the data pump export utility?
Difference between pre-select and pre-query
How to execute a stored program unit?
How to update values in a table in oracle?
What is the difference between post-database commit and post-form commit?
Why we use bulk collect in oracle?
How to save query output to a local file?
Difference between inner join vs where ?
