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 are all the common sql function? : Sql dba

587

Is sql a case sensitive language?

520

how to include numeric values in sql statements? : Sql dba

564

what is the difference between cluster and non cluster index? : Sql dba

558

What is rowid in sql?

512

What are the disadvantages of not performing database normalization?

595

Where not exists in sql?

503

What is the sql*loader? : aql loader

591

How to use transactions efficiently : transact sql

550

What is the difference between a subquery and a join?

531

What are the key differences between SQL and PL SQL?

630

how would you get the current date in mysql? : Sql dba

552

How do you update a value in sql?

549

Can we write dml inside a function in sql server?

501

How to start the command-line sql*plus?

566