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 / kishor solanki @ 9904762204
create table newtable as select * from oldtable order by dupcol;
drop oldtable;
rename newtable to oldtable;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is sql server agent? : Sql dba
What is clustered index in sql?
Why primary key is required?
What is group function in sql?
how to enter binary numbers in sql statements? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
Explain what is rdbms?
How to select all records from the table?
Explain autonomous transaction.
what is primary key? : Sql dba
What is a constraint?
How does an execution block start and end in pl sql?
Does group by remove duplicates?
Explain the the delete statements in sql?
What is sqlcontext?