Home > DeveloperSection > Interviews > what is union in sql server?

Posted on    April-28-2011 12:53 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1231  View(s)
Rate this:

Amit Singh

Total Post:565

Points:2825
Posted on    April-28-2011 12:00 AM

The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type. With UNION, only distinct values are selected.

Don't want to miss updates? Please click the below button!

Follow MindStick