create table newtable as select * from oldtable order by dupcol; drop oldt

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 / kishor solanki @ 9904762204

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

Please Help Members By Posting Answers For Below Questions

What is the file extension for sql database?

1060

What are the main features of cursor?

1108

What can I use instead of union in sql?

1020

how does a local variable is defined using t-sql? : Transact sql

1056

Mention what are the benefits of pl/sql packages?

1151

Why do we use procedures in sql?

1138

Explain what is table in a database?

1107

When is the explicit cursor used ?

1088

How is use pl and sql?

1105

What does plv msg allows you to do?

1177

What is range partitioning?

1012

What are the various restrictions imposed on view in terms of dml?

1014

Can a procedure in a package be overloaded?

1096

what is a foreign key ? : Sql dba

1112

How bulk collect improves performance?

1050