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 the stored procedure?

631

How to create a dml trigger using create trigger statements?

552

What are parameterized reports? What are cascading parameters in ssrs reports?

100

What are the types of dml?

552

What is page in sql server?

513

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

498

Describe and explain about SQL native client?

608

Is oracle faster than sql server?

549

What are different types of statements that are supported by sql?

590

What is a trigger and types of a trigger?

564

What is RMS migrations?

1696

Explain what is lock escalation and what is its purpose?

511

Can another user execute your local temporary stored procedures?

538

Explain the truncate command? : SQL Server Architecture

562

Can we use where and having clause together?

504