Please let me know if UNION ALL and Natural Join does the
same operation and are same...
- 7 Answers
- 13621 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
How to handle bulk data?
What is a join?
what are the differences between char and varchar? : Sql dba
What is cost in sql execution plan?
Is ms sql traffic encrypted?
What is pl sql in oracle?
How much does sqlite cost?
What are pl sql procedures?
Which is faster subquery or join?
What is a database event trigger?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is a sql schema used for?
explain commit and rollback in mysql : sql dba
What is plpgsql language?
What is the difference between delete, truncate and drop command?
