CREATE TABLE new_table as SELECT * FROM test GROUP BY url; DROP TABLE te

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 new_table as SELECT * FROM test GROUP BY url;
DROP TABLE test;
RENAME TABLE new_table TO test;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I run a sql script?

1223

Why select is used in sql?

1068

what is 'trigger' in sql? : Sql dba

1141

What is microsoft t sql?

982

Why do we need view in sql?

1032

How do you optimize a stored procedure in sql?

1014

which types of join is used in sql widely? : Sql dba

1027

What are the two different parts of the pl/sql packages?

1138

What is indexing oracle sql?

1142

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1201

Why we use sql profiler?

1019

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1017

Why do we go for stored procedures?

1121

How to combine two stored procedures in sql?

1319

Can variables be used in sql statements?

1071