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 >> Data Warehouse >> Cognos
  2. Suggest New Category

-------------Diff b/w Union and Unionall?

Question Posted / arkchowdary

Answers were Sorted based on User's Feedback



-------------Diff b/w Union and Unionall?..

Answer / the_xxx

The main difference between UNION ALL and UNION is UNION
only selects distinct values, UNION ALL selects all values
(including duplicates).

Is This Answer Correct ?    11 Yes 0 No

-------------Diff b/w Union and Unionall?..

Answer / abd hfz

UNION gives result set of only distinct values from both
tables where as UNION ALL selects all values including
duplicates.

Is This Answer Correct ?    1 Yes 1 No

-------------Diff b/w Union and Unionall?..

Answer / sridevi

UNION will give only distinct values where as UNION ALL gives all the values including duplicates.Performance wise UNION ALL is faster than UNION because UNION needs to exclude duplicates.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

difference between impromptu and cognos8

0 Answers   HCL,

Tell me about Dnamic and Static Dashboards?

0 Answers  

what is exact catalog size?

4 Answers   IBM,

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

0 Answers  

What are the steps to import the two data sources in framework manager?

0 Answers  

In which types of reports does the page breaks applicable in Cognos...?

1 Answers   IBM,

what are the filters in framework manager and report studio?

0 Answers   IBM,

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

0 Answers   TCS,

how data modeling is usefull to cognos?

1 Answers  

------Diff B/W DrillThrough and master and Detailed Report?

2 Answers   IBM,

What are all the types of hierarchies?

0 Answers  

how to get the all values from a prompt using 'ALL' use and display value in prompt

3 Answers  

For more Cognos Interview Questions Click Here
Categories