Mr. Kondla is almost right, but forgotten to use keyword DISTINCT. It sho

what eliminate duplicate without using roenum and not

Question Posted / satyajit patel

5 Answers
10941 Views
Matrix, I also Faced
E-Mail Answers

Answer Posted / satyajit patel

Mr. Kondla is almost right, but forgotten to use keyword
DISTINCT. It should be like

-> create table T2 as select DISTINT(*) from T1;
-> drop table T1;
-> rename T2 to T1;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is query execution plan in sql?

1249

Explain scalar functions in sql?

1105

What are views in sql?

1037

What is memory optimized table?

1086

How do I partition in sql?

1023

What is a temporal table?

983

What is a unique key?

1106

How does sql store data?

959

Can variables be used in sql statements?

1075

How many parts of a pl sql block are optional?

1219

What is mutating trigger?

1073

what is meant by nl2br()? : Sql dba

1107

What are the operators in sql?

1071

How to disable a trigger name update_salary?

1316

Are stored procedures faster than dynamic sql?

1106