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
- 15077 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
explain primary keys and auto increment fields in mysql : sql dba
what is a control file ? : Sql dba
What happens when a trigger is associated to a view?
What are the types of views in sql?
Can you inner join the same table?
Can we connect to postgresql using sql developer?
Explain dml and ddl?
how to calculate expressions with sql statements? : Sql dba
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Does mysql_real_escape_string prevent sql injection?
explain commit and rollback in mysql : sql dba
Why we use cross join?
What is the advantage of nosql?
Which nosql database is best?
What is native sql query?
