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
25010 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

What are the 3 types of schema?

1112

Which sql server is best?

999

What is sql stored procedure?

1099

What are the difference between “where” and “having” clause in sql server?

1075

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1332

Explain what is dbcc?

1015

What is co-related sub query?

1023

what are user defined datatypes and when you should go for them? : Sql server database administration

1023

What is difference between group by and having?

944

What is policy management?

1000

How to encrypt Strored Procedure in SQL SERVER?

1172

What is table level trigger?

1026

Explain microsoft sql server functions?

1118

What is the index requirement in SQL Azure?

Is BCNF better than 2NF & 3NF? Why?

1050