What is the difference between join and union.
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
tell us something about heap tables. : Sql dba
what are the advantages of sql ? : Sql dba
What are the two characteristics of a primary key?
What are triggers in sql?
What are the different types of joins in sql?
What is mutating table error?
what is column? : Sql dba
What is a common use of group by in sql?
What is sql partition function?
What is dense_rank in sql?
What is scalar data type in pl sql?
What are the benefits of stored procedures?
Explain ddl statements in pl/sql?
What is indexes?
What is varchar example?