Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16435 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
Explain why dimenstion tables are denormalized in nature?
How can you import tables from a database?
What is dimension modeling?
What are fact, dimension, and measure?
Explain what is real time data-warehousing?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is the difference between er modeling and dimensional modeling?
How to export mappings to the production environment?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is a general purpose scheduling tool?
What is application.cfm?
what are the others of "bad files" and "discard files" when using sql*loader?
Where the cache files stored?
Whether dimension table can have numeric value?
Difference between PowerPlay transformer and power play reports?
