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 does sql stand for?

943

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1041

Do we need to create index on primary key?

852

What is a temporal data type?

978

What does inner join mean?

1060

What are different joins used in sql?

1007

How to order siblings in oracle hierarchy queries?

980

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

992

Why is nosql good?

975

How do we accept inputs from user during runtime?

990

Can sql developer connect to db2?

985

How many types of index are there?

958

how can we submit a form without a submit button? : Sql dba

916

What is the purpose of the primary key?

1004

What is the unique index?

1003