SQL: Union and Union All

Suggested by Webmaster on Friday September 25, 2009

UNION is used to combine the result from multiple SELECT statements into a single result set. By default, when it is applied to more than one queries, returns unique result sets only. UNION ALL on the other hand returns all rows in the result set.

Discussion Type: Discussion on Tutorial

Number of topics: 0

Create a new topic

 
  Login or register to create a new topic.  
 

No records to display