Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is UNION,UNION ALL?

Question Posted / sanjudharan

Answers were Sorted based on User's Feedback



What is UNION,UNION ALL?..

Answer / sanjudharan

UNION : eliminates duplicates

UNION ALL: retains duplicates

Both these are used to combine the results of different
SELECT statements.

Suppose I have five SQL SELECT statements connected by
UNION/UNION ALL, how many times should I specify UNION to
eliminate the duplicate rows? -

Once.

Is This Answer Correct ?    22 Yes 9 No

What is UNION,UNION ALL?..

Answer / sandeep

Correct answer..

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More DB2 Interview Questions

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  

what is the difference between where clause and having clause

2 Answers   IBM,

How do I optimize a query in db2?

0 Answers  

What do you need to do before you do EXPLAIN ?

1 Answers  

Can there be more than one cursor open for any program?

0 Answers  

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

What is concurrency in db2?

1 Answers  

What is copy book?

1 Answers   Thomson Reuters,

Are views updateable?

0 Answers  

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

what is a trigger and types of triggers

3 Answers   HSBC,

For more DB2 Interview Questions Click Here
Categories