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

What is function and procedure in pl sql?

986

how to include comments in sql statements? : Sql dba

920

What is a sql statement?

911

What is sqlcommand?

973

What is procedure and function?

936

Is inner join faster than left join?

1131

What is using in sql?

1027

How much does sql cost?

943

Can a table have no primary key?

1016

Is primary key is clustered index?

957

Which is faster truncate or drop?

987

Inline the values in PL/SQL, what does it mean.?

1166

What is the difference between cluster and non-cluster index?

1059

how to create a new table by selecting rows from another table in mysql? : Sql dba

1023

how to drop an existing view in mysql? : Sql dba

1006