how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

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 there a way to automate sql execution from the command-line, batch job or shell script?

794


What is the difference between the conventional and direct path loader? : aql loader

929


What are its different types of dbms?

752


What is an inconsistent dependency?

807


How many aggregate functions are available there in sql?

758


how to see the create table statement of an existing table? : Sql dba

791


what is the command line end user interface - mysql? : Sql dba

742


What is the command used to fetch the first 5 characters of a string?

975


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2236


What does pl sql developer do?

726


Which kind of parameters cannot have a default value in pl sql?

854


what does it mean to have quoted_identifier on? : Sql dba

950


What is compilation error in pl sql?

747


What is interval partition?

778


What are the differences between in and exists clause?

838