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 a scheduled job or what is a scheduled task?

945


What are four major operators that can be used to combine conditions on a where clause?

1035


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2203


What is CTE in SQL

937


how many clustered indexes can be created on a table? : Sql server database administration

1138


How to list all user defined functions in the current database?

1033


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1052


Explain the difference between cross join and full outer join?

974


What have included columns when we talk about sql server indexing?

1028


What does normalization do to data?

1053


How to check if stored procedure is running in sql server?

1042


What are different types of join?

1303


Explain the commands in sql server?

1030


What do you mean by an execution plan? Why is it used?

1007


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

894