Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180554 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 rowtype?
what are the different type of sql's statements ? : Sql dba
Enlist some predefined exceptions?
What is a subquery in sql?
What is query execution plan in sql?
What can I use instead of union in sql?
What are functions in sql?
How do I run a script in sql developer?
Which sql statement is used to return only different values?
How do I run a sql query in pgadmin 4?
What is difference between rank () row_number () and dense_rank () in sql?
Write a sql query to convert all character to uppercase after hypen.
what are tables and fields? : Sql dba
What is a dynamic query?
What is a function in oracle pl sql?
