What are the differences between UNION and JOINS?
Answer Posted / sree
UNION:The SQL UNION operator combines two or more SELECT
statements.
JOINS:SQL joins are used to query data from two or more
tables, based on a relationship between certain columns in
these tables.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How exceptions can be handled in sql server programming?
Explain index in sql server?
What are the differences between clustered and non-clustered index?
How much space does sql server 2016 take?
What is a join in sql? What are the types of joins?
What is the purpose of the model database?
What is the process of indexing?
Explain for xml explicit mode?
Do you know what are the ways available in sql server to execute sql statements?
explain the storage models of olap? : Sql server database administration
What are “lost updates”?
What is de-normalization in sql database administration? Give examples?
What is constraints and its types?
What is the Main Difference between ACCESS and SQL SERVER?
How to enter binary string literals in ms sql server?