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

Explain what is sql*plus?

1138

What are system versioned tables?

1015

What is pragma in sql?

1064

What is the use of prepared statement?

1005

Can you rollback after commit?

973

Why are indexes and views important to an organization?

943

What is the limitation on the block size of pl/sql?

980

What are sql constraints?

1166

Cite the differences between execution of triggers and stored procedures?

1075

What are the rules to be applied to nulls whilst doing comparisons?

1319

Can unique keys be null?

894

What is constant in pl sql?

1012

Which join condition can be specified using on clause?

943

What is a primary key? Explain

965

What are pl sql data types?

1004