Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16289 Views
- IBM, Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / satya
ROLLUP is used to Calculate The subtotals And Grand Total
Based On The Groupby Function.
This ROLLUP is used after the GROUP BY function.
CUBE generates a result set that represents aggregates for
all combinations of values in the selected columns.
RANK Function Is Used To Give The Ranks,But It miss Some
Ranks When Both Are Getting Same Ranks.
DENSE_RANK function Won't Give The Gaps Between The Ranks.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Difference between cold fusion mx 6 and cold fusion mx 7?
can anybody mail me the FAQS for hyperion essbase amd planning
Explain what are non-additive facts?
What a static and local variable?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What are data modeling and data mining? Where it will be used?
List down some of the real time data-warehousing tools?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
explain about dirty dimension?
What is MODEL is Data mining world?
What are the various methods of getting incremental records or delta records from the source systems?
What is your spectra photometer working principles?
What is a real-time data warehouse?
What is VLDB?
Why is business intelligence (bi) important in data warehousing?
