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

Delete duplicate records from the table?(Table must have
unique id)

Answer Posted / manoj

Check following blog post on how to first identify & then delete duplicate records: http://sqlwithmanoj.wordpress.com/2011/10/14/identify-delete-duplicate-records-from-a-table/


This lists multiple ways to delete duplicates.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is repeatable read?

1020


How you can change a cross join into an inner join?

973


what are the three command line utilities and what are their primary functions?

144


Do you know what is xpath?

1088


What is policy based management (pbm)? : sql server database administration

988


What is the simplest way to create a new database in ms sql server?

1010


What are the main sources of data?

1095


What are joins in sql and what are the different types of joins?

1014


What do you understand by the denormalisation?

959


How to recreate an existing index in ms sql server?

1057


What is sql service broker?

982


What is the use of tempdb? What values does it hold?

1072


When you use @@error and try-catch?

1043


What is a rownum?

978


What is temporal data type?

921