Home > DeveloperSection > Interviews > What is UNION,UNION ALL?

Posted on    March-28-2011 5:31 AM

 DB2 DB2 
Ratings:
 1 Answer(s)
  1051  View(s)
Rate this:

Varun Agrawal
Varun Agrawal

Total Post:159

Points:795
Posted on    March-28-2011 12:00 AM

UNION : eliminates duplicates
UNION ALL: retains duplicates
Both these are used to combine the results of different SELECT statements.

Don't want to miss updates? Please click the below button!

Follow MindStick