explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 14923 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 what is fact less fact table? Where you have used it in your project?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
List down some of the real time data-warehousing tools?
What are the data marts?
Which component has onread method and what it is used for?
What is the differences between star and snowflake schemas?
Do you view contain data?
Explain me what is vldb?
What are various warehousing tools?
Explain about core dimension, balanced dimension, and dirty dimension?
Difference between cold fusion 5 and cold fusion mx 6?
Explain the difference between oltp and olap?
Explain what are the basic needs to join two sources in a source qualifier?
What is called data cleaning?
