Please let me know if UNION ALL and Natural Join does the
same operation and are same...
Answer Posted / vasanth
Natural Join and UNION ALL won't give same results.
| Is This Answer Correct ? | 15 Yes | 6 No |
Post New Answer View All Answers
what is sub-query? : Transact sql
Why use truncate instead of delete?
Which version of sql do I have?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is multiple partition?
how many sql dml commands are supported by 'mysql'? : Sql dba
What's the difference between inner join and left join?
What is difference between hql and native sql?
what's the difference between a primary key and a unique key? : Sql dba
What is a join query?
What is a column in a table?
Are stored procedures faster than queries?
What are the query optimization techniques?
Explain the uses of control file.
List out the acid properties and explain?