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

DELETE FROM school WHERE badgeid NOT IN(SELECT MAX
(badgeid) FROM school GROUP BY id);

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is .net mobile images control. Explain with an example? : Microsoft dot net mobile

909


Explain different pipelining hazards and how are they eliminated? : .NET Architecture

973


which is the institute in hyderabad for providing the live project industry training

2757


What is an interrupt? : Dot net architecture

922


Explain different pipelining hazards and how are they eliminated? : Dot net architecture

892


Define cache coherency and how is it eliminated? : Dot net architecture

911


What is a service contract, operation contract and data contract?

899


What is a clickonce application?

893


Define cache? : Dot net architecture

910


Define a virtual memory? : Dot net architecture

878


What are the major differences between services and web services?

897


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

2045


How to improve the cache performance? : .NET Architecture

924


What are bindings?

948


What is the access level of the visibility type internal?

934