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

Write a query to delete duplicate records in SQL SERVER

Answer Posted / subrata paul

Delete TOP(1)from example where[ID]=1

Is This Answer Correct ?    4 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to encrypt Strored Procedure in SQL SERVER?

1154


Your table has a large character field there are queries that use this field in their search clause what should you do?

877


Different types of keys in SQL?

1087


Would you store your query in a ssrs report or a database server? State the reason why?

152


How to download and install the scaled-down database adventureworkslt?

982


Do you know how to make remote connection in database?

953


Do you know what is a trace frag? Where do we use it?

984


What are the benefits of normalization?

1100


What is the recommended total size of your memory optimized tables?

959


What is a cube? : sql server analysis services, ssas

989


What is sqlservr.exe - process - sql server (sqlex?press)?

1098


What is transact-sql ddl trigger?

1099


Can you move the resources after pausing the node? : sql server database administration

1090


Why would you use sql agent?

1254


Can a synonym name of a table be used instead of a table name in a select statement?

1019