Difference between Union and Union All keyword?

Posted by vishalneeraj-24503 on 9/3/2014 | Category: Sql Server Interview questions | Views: 1607 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

1). Both are similar
2). UNION ALL is no longer supported in sql server 2000 onward.
3). UNION returns only unique records from both tables whereas UNION ALL returns all records from both tables.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : By-default Sql server has which isolation level de ...

Next > : Which of the following is one of the basic approac ...

Comments or Responses

More Interview Questions by vishalneeraj-24503

Which of the following is one of the basic approaches for joining tabl ...
Which Global variables can be used to determine if a Transaction is st ...
Mode of storing Asp.Net Sessions are?
Which object can help us to maintain data across Users?
Which elements in the web.config file is used to run code using a perm ...
What attribute will you use to hide a public .Net class from COM?
Which of the following tool is used to install Windows Service?
Which of the following tool is used to manage the GAC?

Latest Interview Questions

What do you mean by 'out' modifier in C# programming language?
What do you mean by 'ref' modifier in C# programming language?
What are the void expressions in C# programming language?
What is operator associative in C#?
What is operator precedence in C#?
What are the assignment expressions in C# programming language?
What are the primary expressions in C# programming language?
In C#, the expression which doesn't perform any operations is know ...
More ...