Please let me know if UNION ALL and Natural Join does the
same operation and are same...
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 language is oracle sql developer?
What are the ways on commenting in a pl/sql code?
List different type of expressions with the example.
Is sql a microsoft product?
What is an index in sql with example?
What is crud stand for?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is dml and ddl?
Explain the uses of database trigger.
what is a unique key ? : Sql dba
What are aggregate and scalar functions?
what is the syntax for using sql_variant_property? : Transact sql
Sql technical questions
How do I run a sql query?
what is user defined functions? : Sql dba