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
- 14607 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
Why stored procedures are faster than query?
where are cookies actually stored on the hard disk? : Sql dba
Why do we need unique key in a table?
How to read/write files from pl/sql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What are operators available in sql?
Why do we need view in sql?
What is information schema in sql?
Does truncate require commit?
What does the sign mean in sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
Explain aggregate functions are available there in sql?
What is the most important ddl statements in sql are?
How to write a query to show the details of a student from students table whose
explain the delete statements in sql
