how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
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
what is the use of friend function? : Sql dba
What is bind variable in pl sql?
What is the basic structure of an sql?
What is a variable in sql?
Do we need to create index on primary key?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what is blob? : Sql dba
Explain the the update statement in sql?
how many tables will create when we create table, what are they? : Sql dba
What are the most important characteristics of pl/sql?
Are left and right joins the same?
What is string join?
What are keys in sql?
What is the purpose of using pl/sql?
what is a field in a database ? : Sql dba