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 / aseem k

Answer Posted / aseem k

Tried and tested:
Table d:
7
8
7

DELETE FROM D WHERE ROWID IN (
SELECT DISTINCT MIN(ROWID) FROM D
WHERE DEPTNO IN
(SELECT DEPTNO FROM D GROUP BY DEPTNO
HAVING COUNT(DEPTNO)>1))

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to specify default values in insert statement using oracle?

1033

State and explain about oracle instance?

928

What is the data pump export utility?

1020

How to load data from external tables to regular tables?

985

What is an oracle transaction?

1051

How to bring a tablespace online?

992

How to get a list of all background sessions in the database?

942

How do I connect to oracle?

974

Can you have more than one content canvas view attached with a window ?

2260

What are the most common interview questions on ETL Testing for experience?

1074

Why does oracle 9i treat an empty string as null?

976

what is the difference between functional dependecy and multilevel dependency?

2419

How to best split csv strings in oracle 9i?

983

What are the differences between date and timestamp in oracle?

972

How to delete a user account in oracle?

911