-------------Diff b/w Union and Unionall?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is a query subjects item?
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
----------------What is Surrogate Key?
Define metrics studio?
What are the different uses of a repository manager?
What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.
how to get the all values from a prompt using 'ALL' use and display value in prompt
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
what is view? types of views?
What is defined as catalog and types of catalogs in Cognos?
Types of Performance Tuning?
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count