A join selects columns from 2 or more tables. A union selects rows.

What are the differences between UNION and JOINS?

Question Posted / saravakumar

Answer Posted / saravakumar

A join selects columns from 2 or more tables. A union
selects rows.

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is it unwise to create wide clustered index keys?

1044

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1095

What is the difference between index seek vs. Index scan?

1063

what is the main function of a query parameter?

155

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1998

How much does sql server 2016 cost?

1157

What is cte (common table expression)?

1085

Explain syntax for viewing trigger?

970

What is the command used to recompile the stored procedure at run time?

1118

What are the limitations in ssrs on sql server express edition?

195

What are the disadvantages of indexes?

1154

Describe the functionalities that views support.

1146

What do you mean by 'normalization'?

1121

What are entities and relationships?

1024

What are different types of schemas?

990