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
What are the types of sql commands?
Give the order of sql select?
How do I view a sql trace file?
how do you know the version of your mysql server? : Sql dba
Can a varchar be a primary key?
Are stored procedures faster than dynamic sql?
What is trigger in sql? Explain
What is the difference between cross join and natural join?
Explain the savepoint statement.
What are the differences between implicit and explicit cursors?
Why schema is used in sql?
What is scope of pl sql developer in future?
Explain unique key in sql.
Can we create a trigger on view?
Explain the steps needed to create the scheduled job?