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

Answer Posted / dharmendra

delete from emp e1 where rowid >(select min(rowid) from emp
e2 where e1.empid=e2.empid)

Is This Answer Correct ?    12 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we call procedure inside function in oracle?

1149

How to assign data of the deleted row to variables?

1115

Where do you use decode and case statements?

1044

How do I call oracle stored procedures that take no parameters?

1202

What is hash cluster in oracle?

1244

How to drop an index in oracle?

1120

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2599

What are the ansi data types supported in oracle?

991

How to rename a tablespace in oracle?

1126

How do I know if oracle is installed on windows?

984

How to declare a local variable?

1173

What is coalesce function?

1146

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2191

What happens if the imported table already exists?

1077

Can I create users through internet explorer in oracle 10g?

1157