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

Explain a private synonyms?

1037

What are joins, explain all types of joins?

2299

What is a proxy object?

1061

What is a tns file?

996

What is merge statement used for?

1024

Does oracle partitioning improve performance?

992

How do I know if oracle is installed on windows?

931

How to change user password in oracle?

1029

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

Explain what are the advantages of views?

1069

How can we delete duplicate rows in a table?

973

Explain the use of rows option in exp command.

1091

what is normalisation?what are its uses?

2273

Can we connect to ORACLE db using Windows Authentication?

1257

How to create a table interactively?

1090