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
- 14893 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / g.srinivasulu
Both are not same why because in UNION ALL operator can
retrive the total number of records from the table and
NATUAL JOIN OR EQUI JOIN operator retrive the rows which
are condition must be the same and datatype of the column
names must be same...
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is normalization in sql?
What is keys and its types?
What does 0 mean in sql?
Why partition by is used in sql?
What is sql*loader?
What is raw datatype in sql?
What are the parts of a sql statement?
What is a table partition?
What is partition by in sql?
what is the difference between truncate and delete statement? : Transact sql
What are all different types of collation sensitivity?
How to rename a column in the output of sql query?
What is the difference between left join and right join?
Does sql*plus have a pl/sql engine?
Explain about various levels of constraint.
