Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16322 Views
- IBM, Ness Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vikram
Diff between RANK() and DENSE_RANK():-
------------*******-----************-------
RANK():-
---> It leaves a gap in the sequence of ranking in the
event of tie.
DENSE_RANK():-
---> It doesn't leave a gap in the sequence of ranking
in the event of tie.
EX:-
empno ename RANK DENSE_RANK
101 AAA 1 1
102 BBB 2 2
102 BBB 2 2
102 BBB 2 2
103 CCC -->5 --> 3
103 CCC 5 3
104 DDD -->7 --> 4
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain the structure of cold fusion?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain the difference between oltp and olap?
What are situations where snowflake schema is better than star schema when the opposite is true?
How to provide security in frame work manager for a query subject?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is a fact table?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
What are the various tools? Explain name a few?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Teradata 
