Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181313 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 is trigger types in sql?
How to read xml file in oracle pl sql?
How long will it take to learn pl sql?
explain primary keys and auto increment fields in mysql : sql dba
how to use regular expression in pattern match conditions? : Sql dba
what is an index? : Sql dba
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is sql procedures and functions?
Does pdo prevent sql injection?
Can we call procedure in select statement?
Explain ttitle and btitle.
How to disable a trigger name update_salary?
how to install mysql? : Sql dba
What are triggers in sql?
what is foreign key? : Sql dba
