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

how to delete duplicate rows from table

Answer Posted / monty

i have other solution if you have table employee with
duplicate rows. You can create other table that doesn't
have duplicate rows


select distinct * into newtable from employee

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between dropping a database and taking a database offline?

1113


What is sub-query in sql server?

1137


How can I know what locks are running on which resource?

893


Will count(column) include columns with null values in its count?

1030


Explain nested join?

920


What is a livelock?

909


What is trace flag in sql server?

974


Show Practically Sql Server Views are updatable?

1052


Mention the command used to rename the database.

944


Explain what is lock escalation?

987


What is @@error in sql?

1020


What are the encryption mechanisms in sql server?

967


What is the data tier application?

169


What are the operating modes in which database mirroring runs?

1022


Do you know what is sql service broker?

992