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
- 14870 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / subathra
union all: Joins the 2 selected results based on different
conditions.
Example:
select a.emp_id, b.dept_id from
emp a, dept b
where a.dept_id=b.dept_id
and a.sal < 3000
union all
select a.emp_id, b.dept_id from
emp a, dept b
where a.dept_id=b.dept_id
and a.sal > 6000
Natural Join: Establish the condition between 2 or more
tables.
Example: select a.emp_id, b.dept_id from
emp a, dept b
where a.dept_id=b.dept_id
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is a unique key ? : Sql dba
how to create a new table by selecting rows from another table in mysql? : Sql dba
Explain the the delete statements in sql?
What are the basic techniques of indexing?
Which join is like an inner join?
Describe types of sql statements?
What are the most important ddl statements in sql?
Is sql dba a good career? : SQL DBA
What is record variable?
what is the difference between union and union all? : Sql dba
What is sql query limit?
How does postgresql compare to "nosql"?
Explain clause in sql?
Can procedure in package be overloaded?
What are %type and %rowtype for?
