Interested to Buy Any Domain ? << Click Here >> for more details...
what eliminate duplicate without using roenum and not
- 5 Answers
- 10699 Views
- Matrix, I also Faced
- E-Mail Answers
Answer Posted / satyajit patel
Mr. Kondla is almost right, but forgotten to use keyword
DISTINCT. It should be like
-> create table T2 as select DISTINT(*) from T1;
-> drop table T1;
-> rename T2 to T1;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are database links used for?
What is group function in sql?
Is sql harder than python?
Is pl sql still used?
How do you drop a trigger?
what is the stuff function and how does it differ from the replace function? : Sql dba
Why is sql*loader direct path so fast?
How long does it take to learn pl sql?
What does a pl/sql package consist of?
what is difference between delete and truncate commands? : Sql dba
What is the basic form of sql query?
What is trigger types of trigger?
How to convert comma separated string to array in pl/sql?
Explain the structure of pl/sql in brief.
what are all the different normalizations? : Sql dba
