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 would you improve etl (extract, transform, load) throughput?

540

What stored procedure would you use to view lock information?

523

What is the chart in report?

111

wat wil hapn if we give the both read and deny read permission to user?

1653

How can we rewrite sub-queries into simple select statements or with joins?

525

What is subquery in sql?

566

What are the types of joins in sql?

559

What is SQL Azure Firewall?

116

How can I get data from a database on another server?

507

What is the difference between a fill factor of 100 and 0?

528

What is encryption key?

What is data compression? : sql server database administration

545

What is identity?

548

In case you have filters in your report, when filters will be applied in cached report instance?

What kind of problems occurs if we do not implement proper locking strategy?

963