Select top 1 * from table where a=1 select top 1* into table1 from table

how to delete duplicate rows in sql server2005

Question Posted / sundaravadivel g

Answer Posted / sundaravadivel g

Select top 1 * from table where a=1

select top 1* into table1 from table where a=1

delete from table

insert into table
select * from table1

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Characterize join and name diverse sorts of joins?

909

Which data type columns are the best candidates for full-text indexing?

917

What is log ldf?

931

How to change parameter value inside the report?

153

Where actually sql azure database is hosted?

161

What is a View ? Can we insert, Update and delete a view?

941

What is a synonym for manipulation?

932

Tell me what is difference between view and materialized view?

882

Explain different types of Normalization.

1734

Why truncate is ddl command?

994

What are system databases into sql server (2005/2008) : sql server database administration

964

What is difference statement and preparedstatement?

934

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1012

what information is maintained within the msdb database? : Sql server administration

913

Mention the differences between substr and charindex in sql server.

983