explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 14927 Views
- IBM, Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / friend
ROLL UP IS USED TO FIND THE SUB TOTALS ,IT IS USED AFTER
GROUP BY FUNCTION,AND"CUBE"IS ALSO HAVING THE SAME
MEANING,AND RANK FUNC IS USED TO FIND THE RANKS AND IT
GIVES THE SAME RANK IF DATA HAVING SAME DATA,AND DENSE
_RANK ALSO SAME AS RANK BUT IT WILL GIVE DISTINCT RANKS IF
AT ALL IF THE DATA HAVING SAME DATA.
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
What are different deliverables according to phases?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is dimension modeling?
What are various warehousing tools?
Explain is fact table?
What is is a star schema?
What are the data types present in bo?
Explain what is analytical or analytic mean?
What are the various transformation available?
List any five applications of data warehouse.
What is the difference between aggregate table and materialized view?
Which columns go to the fact table and which columns go the dimension table?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Describe the differences between a data warehouse and data mart.
