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

Write query to return all rows sql?

1004

Explain temporary table vs table variable by using cursor alternative?

943

What is sql language?

1027

What are views in ms sql server?

1023

Mention the differences between having and where clause.

996

What are dml (data manipulation language) statements in ms sql server?

924

Using the customer, and order table in northwind database, please write a query to produce xml?

1007

What is serializable?

995

What is ems sql management studio? : sql server management studio

1035

Does sql server 2000 full-text search support clustering?

814

What should be the fill factor for indexes created on tables? : sql server database administration

1099

can SSRS reports Cache results?

136

Explain about remote stored procedure?

964

Explain unique key in sql server?

953

What is faster join or union?

1108