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

i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?

2829


what are the fundamental and common properties of .net controls?

2164


Differnce between managed code and unmanaged code ?

1143


Explain Singleton design pattern in .net

1048


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.

15149


What are the different pipelining hazards? : Dot net architecture

1070


What does this do? Gacutil /l | find /i "corillian"

1078


Explain different pipelining hazards? : Dot net architecture

1043


How can I write my own .NET host?

1047


Explain the five stages in a dlx pipeline? : .NET Architecture

964


I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....

1926


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

1090


12. Types of polymorphisem[Run and Design Exp.]

2122


What is an asssembly qualified name? Is it a filename? How is it different?

995


any one can explain about projectarchitecture and project approach briefly

2565