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

delete from students where badgeid not in (select max(id)
from students group by badgeid);

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name some changes done since version 3.0?

976


What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile

958


What is cache coherency? : Dot net architecture

1031


Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.

956


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

1878


Explain element .net mobile with example? : Microsoft dot net mobile

988


Explain a .net mobile example with details? : Microsoft dot net mobile

884


what are constructors and destructors?

2158


Explain 'managed' mean in the .NET context

1136


Explain difference between machine config vs. Web config : Dot net architecture

899


Waht is Dot net Arcitecture

2410


Explain about appdomains?

1037


What are the types of application software?

961


what is polymorphism and advantage ?

1997


Explain hard disk and what is its purpose? : .NET Architecture

937