Interested to Buy Any Domain ? << Click Here >> for more details...
what eliminate duplicate without using roenum and not
- 5 Answers
- 10740 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 sqlerrd?
What are the qualities of 2nf?
What is sql procedures and functions?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What are the various restrictions imposed on view in terms of dml?
Why do we create stored procedures & functions in pl/sql and how are they different?
Which language is used in sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Explain the types of joins in sql?
what are set operators in sql? : Sql dba
Explain alias in sql?
What is nosql db?
what is a primary key? : Sql dba
What is the use of sql trace?
What are aggregate and scalar functions?
