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 are the types of subquery? : Sql dba

825

What is sql catalog?

819

What is difference between cursor and trigger?

816

Can pl sql procedure have a return statement?

774

What is sql architecture?

811

What is scalar function in sql?

766

What are the different types of a subquery?

763

How to Execute a Package in PL/SQL.?

860

What is the difference between a primary key and a unique key?

802

Is primary key is clustered index?

759

what is isam? : Sql dba

805

Are subqueries better than joins?

762

Can a procedure in a package be overloaded?

814

Is mariadb a nosql database?

816

What are the parts of a sql statement?

836