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 include comments in sql statements? : Sql dba
What is constant in pl sql?
how to return query output in html format? : Sql dba
Is sql low level language?
what are the differences between require and include, include_once and require_once? : Sql dba
What is the main reason behind using an index?
What is mutating table error?
How many joins in sql?
Why do we need pl sql?
What is oracle pl sql developer?
What does the acronym acid stand for in database management?
How to get help at the sql prompt?
What is pragma in pl sql?
What is the difference between cross join and natural join?
What is substitution variable in pl sql?