First add an Identity Column in table Alter table <tblname> Add

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / arif jameel

11 Answers
19599 Views
UST, I also Faced
E-Mail Answers

Answer Posted / arif jameel

First add an Identity Column in table

Alter table <tblname>
Add < New_columnID > int identity(1,1)

Delete from <tblname> where < New_columnID> in
(select max(New_columnID)from <tblname>
Group by <tbl_columnname>
having count (<tbl_columnname>)>1)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is normalisation and its types?

1042

Is sql an operating system?

1071

what are all the common sql function? : Sql dba

1102

What does data normalization mean?

1025

What is audit logout in sql profiler?

1073

Is mariadb a nosql database?

1095

Why function is used in sql?

990

How do I install microsoft sql?

1111

What is clustered index sql?

1029

Can you join a table to itself?

1219

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1063

What is materialized view. What are different methods of refresh?

1437

Why do we need pl sql?

1033

What is pl sql record in oracle?

1087

What is the usage of distinct keyword?

1111