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

7 Answers
13512 Views
Cisco, CTS, HCL, IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain unique key in sql server?

1013

What is normalization and its types?

1041

How to disable a login name in ms sql server?

1138

How to maintain a fill factor in existing indexes?

1006

Explain datetime2 data type in sal server 2008?

919

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

908

Where to find ntwdblib.dll version 2000.80.194.0?

963

How do you rebuild an identity column?

951

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1962

What are the different types of backups avaialabe in sql server 2005?

1022

How to filter records of table in SQL SERVER?

1087

What are null values in ms sql server?

1095

Can you index views?

899

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

1016

What does the not null constraint do?

1103