What are the differences between UNION and JOINS?

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

Do you know hot add cpu in sql server 2008?

727


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

744


Can you force a query to use a specific index?

691


What is relationship? What number of sorts of relationship are there?

817


Which command is used for user defined error messages?

738






What are the three different part of rdl file explain them?

214


How do I manually uninstall an instance of sql server 2016?

715


difference between Clustered index and non clustered index ?

742


Can we write ddl in trigger?

650


Explain the xml support sql server extends?

809


do you know how to configure db2 side of the application? : Sql server database administration

777


How do you check sql server is up and running?

690


How do I save a stored procedure in sql server?

668


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1102


What is the difference between ddl,dml and dcl commands?

810