OOPS - what is diff between union / union all

GeekInterview.com > Interview Questions > J2EE > OOPS

Go To First | Previous Question | Next Question

OOPS | Question 13 of 30

what is diff between union / union all

Total Answers and Comments: 3

Last Update: February 13, 2008 Asked by: SUNDARAMOORTHYS

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 20, 2006 22:55:17

Mahipal Rawat

RE: what is diff between union / union all

Union- From both table only the unique record will come

Union All- In this case duplicate record will also come

Is this answer useful? Yes | No

June 18, 2007 03:56:28

ramanareddy devarapalli

RE: what is diff between union / union all

UNION does it will not allows duplicate value, where as UNION ALL allows the duplicate values.

Is this answer useful? Yes | No

February 13, 2008 05:07:35

sampra

Member Since: February 2008 Contribution: 279

RE: what is diff between union / union all

Union dosent allow duplicate value
Union all allows duplicate value

Is this answer useful? Yes | No