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

Explain can you implement data mining in ssrs?

161

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1054

How to create a large table with random data for index testing in ms sql server?

1067

What are the grouping functions?

973

How to encrypt Strored Procedure in SQL SERVER?

1226

What are orphan records?

985

What is sleeping status in sql server?

1074

How to use old values to define new values in update statements in ms sql server?

1330

What is the difference between clustered and a non-clustered index?

1074

Can we use pragma autonomous_transaction in trigger?

1013

Explain the difference between primary keys and foreign keys?

1098

Explain system rowset functions?

1043

Is sql server is free?

1017

Can you explain various data region available in ssrs with their use?

1020

What are various limitations of the views?

1090