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

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

Answer Posted / ruban

Use ROWID function. It's available only sql server 2005 and
greater

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 open database communication (odbc)?

1063


What is sql server replication? : sql server replication

991


Explain Geometry datatype in sql server 2008 with example

991


How to download microsoft sql server 2005 express edition?

1047


What can be used instead of trigger?

1156


What is store procedure? How do they work?

1022


Why union all is faster than union?

913


what is package and it uses and how can u call a package

2014


What is Dependency Injection and provide example?

1117


Tell me what do we need queues in sql service broker?

994


Can you pass expressions to function parameters?

1103


What is user-defined scalar function?

968


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1750


Explain syntax for viewing, dropping and disabling triggers?

953


Do you know data definition language, data control language and data manipulation language?

1040