What is diff between union / union all

  • Interview Candidate
  • 3
  • 1889

Showing Answers 1 - 3 of 3 Answers

Mahipal Rawat

  • Mar 20th, 2006
 

Union- From both table only the unique record will come

Union All- In this case duplicate record will also come

  Was this answer useful?  Yes

ramanareddy devarapalli

  • Jun 18th, 2007
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions