programming faqs interview questions tech technical educational freshers guide preparation interviews hr telephonic
try another color:
try another fontsize: 60% 70% 80% 90%
ProgrammingFAQs

what is difference between UNION and UNION ALL

Mon, 06/09/2008 - 21:07 — Anonymous

UNION: combines the result

Wed, 06/11/2008 - 03:25 — admin

UNION: combines the result sets of two queries with distinct values
UNION ALL : Simply combines the result set of both the queries, it shows duplicate rows also