Please let me know if UNION ALL and Natural Join does the
same operation and are same...
- 7 Answers
- 13620 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
What is sql table?
how do you know if your mysql server is alive? : Sql dba
How do I order columns in sql?
What are sql indexes?
What are the types of variable use in pl sql?
What found sql?
What is a schema sql?
what are the nonstandard string types? : Sql dba
How do I debug a stored procedure?
How do I run a query in pl sql developer?
What is gpt format?
How can I change database name in sql?
what is the difference between char and varchar data types? : Sql dba
What is a sql schema used for?
Explain the components of sql?
