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
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is the difference between the conventional and direct path loader? : aql loader
What are its different types of dbms?
What is an inconsistent dependency?
How many aggregate functions are available there in sql?
how to see the create table statement of an existing table? : Sql dba
what is the command line end user interface - mysql? : Sql dba
What is the command used to fetch the first 5 characters of a string?
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..
What does pl sql developer do?
Which kind of parameters cannot have a default value in pl sql?
what does it mean to have quoted_identifier on? : Sql dba
What is compilation error in pl sql?
What is interval partition?
What are the differences between in and exists clause?