Delete duplicate records without using sub query?

Delete duplicate records without using sub query? Is That possible

Questions by Rakesh057   answers by Rakesh057

Showing Answers 1 - 12 of 12 Answers

Raud Premananda

  • Jul 7th, 2014
 

USING "ROWID" PSEUDO COLUMN YOU CAN DELETE DUPLICATE RECORDS

Manoj Yadav

  • Mar 22nd, 2016
 

Using Max "Rowid"

  Was this answer useful?  Yes

kadari ashok

  • Jul 14th, 2016
 

We can do through co-related sub query

  Was this answer useful?  Yes

Aak

  • Sep 15th, 2016
 

Use a temp table, store distinct rows. Either delete the old table and rename this new table with the old table name or truncate old table and insert rows from temp table to the old table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions