WHAT IS UNION,UNION ALL?

Varun Agrawal

Total Post:159

Points:795
Posted by  Varun Agrawal
DB2 
DB2
 1210  View(s)
Ratings:
Rate this:
  1. Varun Agrawal

    Post:159

    Points:795
    What is UNION,UNION ALL?

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!