What is the difference between join and union.
- 27 Answers
- 173043 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / venki
A join is used to combine rows from multiple tables. A join
is performed whenever two or more tables is listed in the
FROM clause of an SQL statement.
Combines the results of two SELECT statements into one
result set, and then eliminates any duplicate rows from
that result set
| Is This Answer Correct ? | 40 Yes | 57 No |
Post New Answer View All Answers
What are tables in sql?
What is pl sql architecture?
How do we use distinct statement? What is its use?
How do I install sql?
What is sql*plus?
what is an alias command? : Sql dba
what is auto increment? : Sql dba
What is sql exception?
Why is a primary key important?
what is a materialized view? : Sql dba
What are user defined functions?
How many types of primary keys are there?
What is gpt format?
how to calculate expressions with sql statements? : Sql dba
What is meant by <> in sql?
