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

What is blu acceleration in db2?

0 Answers  

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

What is the meaning of -805 SQL return code?

3 Answers  

Mention some fields that are a part of sqlca.

0 Answers  

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

What are the contents of a DCLGEN?

4 Answers   MetLife,

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

what is rebinding ?

1 Answers   IBM,

What is a clustering index ?

3 Answers  

Is db2 a programming language?

0 Answers  

What is isolation level in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories