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
18770 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 are the uses of sysdate and user keywords?

1046

What are the different types of dbmss?

960

In a distributed database system, can we execute two queries simultaneously?

990

Explain the uses of database trigger.

1053

What is the difference between union and union all command?

1006

What is minus?

940

What does a pl/sql package consist of?

926

Is id a reserved word in sql?

1088

how to shutdown mysql server? : Sql dba

1027

Is a secondary key the same as a foreign key?

952

What is a loop in sql?

935

How to avoid using cursors?

1035

what are all the different normalizations? : Sql dba

952

What is a database trigger?

1016

how many columns can be used for creating index? : Sql dba

892