Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

how to delete all duplicate records from a table using
subquery?

Question Posted / edara satish

Answer Posted / edara satish

delete from
<<table_name>>
where rowid in
(select a.rowid
from <<table_name a,table_name b>>
where a.colname = b.colname
b.colname2 = b.colname2
......
...
a.colnamen = colnamen
order by .... desired colnames)

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between hot backup vs. Cold backup?

1006

How do I manually uninstall oracle client?

1098

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2336

Explain about integrity constraint?

1136

How to use "startup" command to start default instance?

1046

How to create a table index in oracle?

1141

How to find the duplicate rows count from employees table in oracle?

1105

What are the uses of Database Trigger ?

1731

How to assign values to data fields in record variables?

1042

Can we call procedure inside function in oracle?

1105

How do I know if oracle is installed on windows?

942

Describe varray?

1065

How to install oracle database 10g xe?

1029

What are the different types of partitions in oracle?

984

How to run queries on external tables?

1056