ADD a new identity_column (1,1) on <table> by alter table <ta

How To delete duplicate record from a particular table?

Question Posted / arif jameel

12 Answers
24927 Views
eXensys, Foxfire, I also Faced
E-Mail Answers

Answer Posted / arif jameel

ADD a new identity_column (1,1) on <table>
by

alter table <table_name>
add <Identity_column> int identity(1,1)

delete from <table> where <identity_Column> in
(select max(<identity_Column>) from <table>
group by any <table_column_name>)

drop <identity_column>

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to identify current user in ssrs report?

401

Tell me what is a linked server?

1034

What are the lambda triggers?

893

How to insert new line characters into strings?

982

What does null mean?

980

List some case manipulation functions in sql?

1019

What is the purpose of floor function?

1027

How do I start sql server?

963

What do you mean by acid?

983

How to delete multiple rows with one delete statement in ms sql server?

1000

How do I perform an unattended install of sql server 2000?

1078

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

How to use copy and concatenate commands in SQL?

1138

What are pessimistic lock and optimistic lock?

1064

What is a trigger in sql server?

1161