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

What is server-level principal?

122

What does it mean to normalize data?

994

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1060

How to set database to be read_only in ms sql server?

1050

Explain difference between control flow and data flow?

1013

explain what is raid and what are different types of raid configurations? : Sql server database administration

1049

How do I find my localdb version?

1025

How to get a list of columns in a view using "sys.columns" in ms sql server?

1037

How can change procedure in sql server?

1123

Some queries related to SQL

1033

What is save transaction and save point?

1254

How to locate and take substrings with charindex() and substring() functions?

1070

What is a trace frag? Where do we use it?

1149

How can we call UDF(User Define Function) using C# code in ASP.net ?

6946

What are the benefits of filtered indexes?

1093