Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16459 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
How do you define data block size?
Can decision tree be implemented using SQL?
What is a relationship?
What is a general purpose scheduling tool?
Where the applications and where
What is dimensional modelling?
List any five applications of data warehouse.
What are the types of dimensional modeling?
Explain difference between snow flake and star schema.
What is incremintal loading?
How can you set the client management?
Explain what is the difference between olap and datawarehosue?
What is the difference between star and snowflake schemas?
How to performance tune reports?
What are situations where snowflake schema is better than star schema when the opposite is true?
