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
- 14902 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
Why do we use function in pl sql?
How do you create an update query?
What is rtm stands for?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the use of partition by in sql?
what is user defined functions? : Sql dba
What is the difference between instead of trigger and after trigger?
What are sql indexes?
What are all the different normalizations?
What is natural join in sql?
What is lexical units in pl sql?
what are ddl statements in mysql? : Sql dba
How does sql profiler work?
What is the use of sql trace?
How to run sql statements through the web interface?
