Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 179545 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
Explain the difference between triggers and constraints?
What is trigger and stored procedure in sql?
what are numeric data types? : Sql dba
Why we use sql profiler?
how to rename an existing column in a table? : Sql dba
What is the maximum rows in csv?
how to convert character strings to dates? : Sql dba
define join and explain different type of joins? : Sql dba
How do I copy a table in sql?
What is rowtype?
What is the difference between the conventional and direct path loader? : aql loader
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How do you create a unique index?
What is cross join sql?
what are the t string functions available in tsql? : Transact sql
