select distinct eno,ename into temp_table from main

how to delete duplicate rows in sql server2005

Question Posted / apps

Answer Posted / apps

select distinct eno,ename into temp_table from main_table
drop table main_table
-----
sp_rename temp_table,main_table

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the different types of backups available in sql server? : Sql server database administration

934

What are various ways to enhance the ssrs report?

987

How many non clustered indexes there can be on table ?

920

What are character string data types in ms sql server?

1259

Tell me what are cursors and when they are useful?

956

How do you Implement SSIS Packages in your Project?

1932

Are all views updatable ?

1155

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1009

What is format parameter in ssrs?

146

How many full-text indexes can a table have?

975

How to create a new schema in a database?

1152

How many database files are there in sql server 2000?what are they?

1053

how can you attach more than 20 ldf files in sql server

2004

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

996

List down some advantages of sql stored procedure?

967