What the difference between UNION and UNIONALL?

  • Interview Candidate
  • 4
  • 6016

Showing Answers 1 - 4 of 4 Answers

padmanabhanr

  • Jul 25th, 2006
 

Yes the Above said answer is correct

  Was this answer useful?  Yes

Sachin

  • Aug 3rd, 2006
 

Union will remove the duplicate rows from the result set while Union all does'nt.

  Was this answer useful?  Yes

Vasanth Kumar

  • Oct 6th, 2006
 

UNION - returns on Distinct rows/Slower in performanceUNION ALLL- Returns duplicate rows/Faster Performance

  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