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...

How to delete the duplicate records from table(having bulk
records)?

Answer Posted / rajani

delete from emp where rowid not in ( select max(rowid) from emp group by empno )

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture

1075


Does .NET runtime offer Deterministic Destruction or not?

968


Explain some of the disadvantages due to microsoft.net?

947


How do we do authentications using atlas?

930


What is the purpose of cache? : Dot net architecture

950


What does the term "green architecture" mean? : .NET Architecture

923


What are the important principles of soa (service oriented architecture)?

882


Explain difference between machine config vs. Web config? : .NET Architecture

923


how to add list of items in a web application and win application?

2042


How cache coherency is eliminated? : Dot net architecture

877


Is .net easier than java?

884


Define pipelining? : Dot net architecture

979


The maximum report processing jobs limit configured by your system administrator has been reached.How I can Solve this problem when i using crystal report to load from my application.

14961


how to use custom field validation

2444


what are constructors and destructors?

2099