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

How to link tables in sql server?

922

in the physical file layout, where should the transaction log be stored in relation to the data file?

986

Explain the truncate command? : SQL Server Architecture

1161

Explain powershell included in sql server 2008?

1043

role of sql sever 2005 in database rather than any other database

1928

How to change the data type of an existing column with "alter table" statements in ms sql server?

976

Explain unique key in sql server?

1004

What are data regions?

135

What are various aggregate functions that are available?

971

How to turn on the mssql api module in php?

1065

Explain four layers of abstraction microsoft architectured?

147

Explain nested trigger in sql?

1062

What do you mean by data integrity?

1060

Explain an incremental backup?

992

What is the return type of executeupdate ()?

896