Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181270 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / somashekhar m
Union : The union operator combines the results of two or
more queries into a single result set. But no.of columns
must match in both/all the queries (and also the order)
which are used for union.
Union -- returns with no duplicate rows
Union all -- retruns with duplicate rows (No. of rows
returned = No. of rows in Query1 + No. of rows in Query 2)
Union is a set operator.
You cannot use the union operator within a create view
statement.
You cannot use the union operator on text and image columns.
You cannot use the for browse clause in statements
involving the union operator.
Joins: Joins are used to extract information from more than
one table based on the related column/coloums (PK and RFK)
any no. of rows can be retrived based on matching matching
colums. Different types of joins are Inner join=equi join=
join, outer join(Right outer join/right join, Left outer
join/ left join), Cross join, and full outer join/outer join
| Is This Answer Correct ? | 139 Yes | 20 No |
Post New Answer View All Answers
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
how is exception handling handled in mysql? : Sql dba
What is sqlca in db2?
How to use transactions efficiently : transact sql
what is 'mysqlcheck'? : Sql dba
What is lexical units in pl sql?
What is procedure and function?
How do you update f as m and m as f from the below table testtable?
What are properties of the transaction?
Differentiate pl/sql and sql?
Is sql procedural language?
What is consistency?
Differentiate between syntax and runtime errors.
What is the difference between truncate and drop statements?
What is faster join or subquery?
