What is the difference between join and union.
Answer Posted / vijay kulkarni
In Join, matching rows are joined side-by-side to make the
result table but whereas in Union rows are joined one-below
the other to make the result table.
| Is This Answer Correct ? | 21 Yes | 33 No |
Post New Answer View All Answers
Why is stored procedure faster than query?
What is the command used to fetch the first 5 characters of a string?
How do I run sql?
What is index example?
Can you call pl/sql package functions from within a fast formula?
What are different types of sql commands?
What is the difference between subquery and correlated query?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What are types of joins?
What is rownum and rowid?
What are different types of tables in sql?
What is the difference between in and between in sql?
What is inner join in sql?
what is the difference between primary key and unique key? : Sql dba
What is the difference between Union and Union all. Which is faster.