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

Please Help Members By Posting Answers For Below Questions

Benefits of Stored Procedures?

1037

Does order by actually change the order of the data in the tables or does it just change the output?

1203

Explain “not null constraint” in sql server?

1085

How can I check that whether automatic statistic update is enabled or not?

1091

Why we need to use secondry database file? though, we can do same work using primary database file also.

6999

What are the new features are introduced in sql server 2012 reporting services?

160

what is a transaction and what are acid properties? : Sql server database administration

1079

Explain magic tables in sql server?

1097

What is an indexing strategy?

1062

How to drop an existing stored procedure in ms sql server?

1083

Tell me about normalization in DBMS.

1055

Can two different columns be merged into single column? Show practically?

1116

Can a trigger be created on a view?

987

What is data modeling and Reterminal integrity?

2006

Can group functions be used in the order by clause in ms sql server?

1064