Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180561 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / prasad
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.
The UNION operator is used to combine the result-set of two or more SELECT statements.
Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by stored procedures?
Why do we use %rowtype & %type in plsql?
What are the differences between implicit and explicit cursors?
What is the use of double ampersand (&&) in sql queries? Give an example
What is the difference between nvl function, ifnull function, and isnull function?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is group by in sql?
Are dml statements autocommit?
what are all types of user defined functions? : Sql dba
What is sql deadlock?
Can we use views in stored procedure?
Write a unique difference between a function and a stored procedure.
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What are the types of keys?
What are the types of dbms?
