Interested to Buy Any Domain ? << Click Here >> for more details...
Please let me know if UNION ALL and Natural Join does the
same operation and are same...
- 7 Answers
- 14869 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / swathi
no,both are not same.we are using the union all condition ,we will get the duplicate columns and which field we are selecting it get the total information of that ,But by using Natural join we can't get the all information,some columns are removed.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we write dml inside a function in sql server?
what is a unique key ? : Sql dba
How is debugging done?
How do you update a value in sql?
Define the select into statement.
How can a pl sql block be executed?
what is an alias command? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
Which join is default?
Can delete statement be rollbacked?
Is pl sql useful?
How do I remove all records from a table?
Sql technical questions
What is the maximum number of columns in sql table?
Is pl sql better than sql?
