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 are the difference between data mart and data warehouse? : sql server analysis services, ssas

1008


What is a trigger? Why we need it?

1053


What are the main sources of data?

1142


How do you size a resultset?

965


How to apply filtering criteria at group level with the having clause in ms sql server?

1044


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1008


Differentiate between sql temp table vs table variable?

927


Explain about nested stored procedure?

1080


How to assign new column names in a view?

957


Explain the properties of subqueries in sql server?

1137


How to delete duplicate rows from table except one?

1041


What is the difference between a clustered index and a non-clustered index?

1057


What are different types of replication in sql server?

1142


Distinguish between nested subquery and correlated subquery?

1112


What is Replication?

1106