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

What is a rownum?

505

What will happen if a column containing char type data is changed to the nchar data type?

627

What is sub query and its properties?

549

What is the most common type of join?

532

How to use go command in "sqlcmd"?

648

what is a check constraint?

644

What is difference between commit and rollback when used in transactions?

504

what are different types of raid configurations? : Sql server database administration

490

How to return the second 5 rows in ms sql server?

634

Why would you use sql agent?

738

Can sql servers linked to other servers like oracle?

548

How to get a list all databases on the sql server?

583

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

1658

How to change the password of a login name in ms sql server?

563

Is resultset an interface?

560