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 normalization? How many normalization forms are there?

1022

How do rank () and dense_rank () differ?

985

What's the difference between a primary key and a clustered index?

951

What is sql dialect?

1047

Can we rollback after truncate?

993

How do you update f as m and m as f from the below table testtable?

1802

Explain the working of primary key?

1046

what is unique key constraint? : Sql dba

997

How many tables can you join in sql?

909

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

998

Is ms sql is free?

970

What is the main difference between sql and pl/sql?

1038

What is difference between ms sql and mysql?

921

Does truncate need commit?

899

What is character functions?

1024