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

11 Answers
19249 Views
UST, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql the best database?

976

Why left join is used in sql?

980

Explain what is a database?

1087

What is difference between sql function and stored procedure?

1007

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4010

What is sql data?

996

Do we need to create index on primary key?

929

what is oracle database ? : Sql dba

1030

How do you identify a primary key?

1063

Does a primary key have to be a number?

964

What is difference between ms sql and mysql?

964

How is use pl and sql?

1064

How to use sql statements in pl/sql?

1122

What does 0 mean in sql?

966

Can we join 3 tables in sql?

1043