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
- 14592 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 the use of sqlerrd 3?
how to check server status with 'mysqladmin'? : Sql dba
what are string data types? : Sql dba
How do you declare a variable in pl sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
How do you clear the screen in sql?
What is fmtonly in sql?
What is the maximum number of triggers, you can apply on a single table?
Which are the different case manipulation functions in sql?
What is a natural join sql?
What is a left join?
How do I create a sql script?
When to use inner join and left join?
What is the difference between delete and truncate statement in sql?
How to call shell script from pl sql procedure?
