Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180505 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / nafisul haque
Join returns matching/non matching records as per condition
where as union returns union of recordsets. Join is used
within single select statement while union is used among
two or more select statements.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is the difference between sql and t-sql? : Transact sql
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How to disable a trigger name update_salary?
How to order siblings in oracle hierarchy queries?
How to load data with sql*loader?
Is oracel sql developer written in java?
What is the need of a partition key?
Can pl sql procedure have a return statement?
How do I delete a trigger?
What are transaction and its controls?
What are the ways on commenting in a pl/sql code?
What is normalisation in sql?
What are sql functions? Describe in brief different types of sql functions?
what is union? : Sql dba
what is sql? : Sql dba
