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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Is it possible to delete duplicate rows in a table without
using a temporary table ?

Question Posted / nithya

Answer Posted / nithya

If u no know the ROWID then u can delete the duplicate rows.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the steps to use transact-sql cursor?

1067

What is the fillfactor concept in indexes?

989

To which devices can a backup be created and where should these devices be located? : sql server management studio

1047

Why use sub query in sql server and list out types of sub queries?

1000

How to update muliple row in single query?

1062

What is RAID? What are the different types of RAID configurations?

1136

Explain the microsoft sql server delete command?

1025

What is the difference between commit and rollback?

947

What new data source types were added in ssrs 2014?

160

How to drop existing indexes in ms sql server?

1072

Explain multiserver query

1047

Can you tell me some of the common replication dmv's and their use? : sql server replication

928

What is the difference between dataadapter and datareader?

1007

what protocol both networks use? : Sql server database administration

974

How does clustered and non clustered index work?

927