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 is the difference between sql and isql*plus?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Is progress software supports to ( pl/sql )?
Is nosql faster than sql?
How to combine two stored procedures in sql?
What is primary key sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is the source code of a program?
What is pl sql block in dbms?
Can I learn sql in a week?
List the various privileges that a user can grant to another user?
Is sql procedural language?
What are the benefits of pl sql?
How do I partition in sql?
What is column?