SQL - What is the difference between UNION and UNION ALL ?

GeekInterview.com > Placement Papers > Manhattan Associates > SQL

Go To First | Previous Question | Next Question

SQL | Question 2 of 4

What is the difference between UNION and UNION ALL ?

Total Answers and Comments: 3

Last Update: July 25, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: biswaranjanbehera

in "union" only distinct values will be selected but in "union all "values will be selected irrespective of its frequency.

Above answer was rated as good by the following members:
biswaranjanbehera

March 14, 2005 15:37:52

kris

RE: What is the difference between UNION and UNION ALL ?

The difference between UNION ALL and UNION is that while UNION only selects distinct values UNION ALL selects all values.

Is this answer useful? Yes | No

June 06, 2005 07:25:06

Nagaraja Rao

RE: What is the difference between UNION and UNION ALL ?

Union will filter duplicate values where as union all will not filter duplicate values

Is this answer useful? Yes | No

July 25, 2008 05:12:59

biswaranjanbehera

Member Since: July 2008 Contribution: 4

RE: What is the difference between UNION and UNION ALL ?

in "union" only distinct values will be selected but in "union all "values will be selected irrespective of its frequency.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank