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 many rows can sqlite handle?

1103

How do I run a pl sql program?

1121

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1033

Can we update views in sql?

933

What is meant by user defined function?

1037

What is difference between nchar and nvarchar?

1020

In pl/sql, what is bulk binding, and when/how would it help performance?

986

What is sql indexing?

1005

What is user in sql?

1014

What is an escape character in sql?

1019

What are the different types of functions in sql?

1044

Who is the owner of mysql database?

1053

What is a pl/sql block?

1210

Name three sql operations that perform a sort.

998

Can we insert in view in sql?

1045