What is the difference between join and union.
Answer Posted / preeti mishra
Join:- Joins are used to query data from two or more
tables, based on a relationship between certain columns in
these tables.
Union:- UNION operator combines two or more SELECT
statements.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Difference between table function and pipelined function?
What are few of the schema objects that are created using PL/SQL?
What view means?
Explain the the update statement in sql?
How does left join work in sql?
What is cascade in sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
How can triggers be used for the table auditing?
Explain unique key in sql.
Explain architecture of sql server notification services?
what is the difference between union and union all? : Sql dba
What is a recursive stored procedure?
Can a view be mutating? If yes, then how?
How can you tell the difference between an index and a view?
What are pl sql procedures?