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
- 14880 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 connect a sql*plus session to an oracle server?
What is not in sql?
Is sql a scripting language?
how would concatenate strings in mysql? : Sql dba
What is the use of count (*) in sql?
What is sql procedures and functions?
What is the difference between local and global temporary table?
How to run sql functions in pl/sql?
What is the limitation on the block size of pl/sql?
What is the difference between the implicit and explicit cursors?
What is the most important ddl statements in sql are?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
what is a relationship and what are they? : Sql dba
Write a sql query to convert all character to uppercase after hypen.
What is a join query?
