Interested to Buy Any Domain ? << Click Here >> for more details...
what eliminate duplicate without using roenum and not
- 5 Answers
- 10562 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 is a parameter query?
What jobs use sql?
What is embedded sql in db2?
What is foreign key and example?
What does over partition by mean in sql?
What is bulk collect in pl sql?
Is and as keyword in pl sql?
Explain locks? : Transact sql
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is the use of sql trace?
How many types of index are there?
Can one improve the performance of sql*loader? : aql loader
What does sql stand for?
What is secondary key?
How do you write a subquery?
