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?

158

Why do we use functions?

913

In what version of sql server were synonyms released?

942

In which files does sql server actually store data?

904

Explain hostprotectionattribute in sql server 2005?

1028

Explain filestream storage of sql server 2008?

1016

How to copy data from one table to another table?

996

How would you use user_constraints table in DB?

1008

What are the types of database recovery models?

1124

What is Command line parameters in PLSQL.?

1128

What does man by sql wildcard characters in sql server?

1059

What is the difference between ddl and dml?

1047

If no size is defined while creating the database, what size will the database have?

991

How to list all triggers in the database with sys.triggers in ms sql server?

1081

what are user defined datatypes? : Sql server database administration

966