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 / noor

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


Please Help Members By Posting Answers For Below Questions

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1040

What privilege is needed for a user to connect to oracle server?

984

How to create an initialization parameter file?

1032

Explain the use of file option in exp command.

1121

How to display row numbers with the records?

1071

What are the numeric comparison operations?

1102

What is an oracle wallet?

934

Explain rename?

969

How to pass a cursor variable to a procedure?

1097

How will you differentiate between varchar & varchar2?

1035

How to define a procedure inside another procedure?

1008

What are the different pseudo commands? Explain in general?

1068

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2362

How to set up autotrace for a user account?

1047

Why should I use oracle database?

980