What is the difference between join and union.
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
how to create a new table in mysql? : Sql dba
List the ways to get the count of records in a table?
What are joins in sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
what is a composite primary key ? : Sql dba
How many sql core licenses do I need?
How do I edit a stored procedure?
What is sqlcontext?
What is embedded sql what are its advantages?
What are the steps for performance tuning.
How to raise user-defined exception with custom sqlerrm ?
Is left join inner or outer?
What is the main difference between sql and pl/sql?
What is schema in sql example?
What is bitemporal narrowing?