explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
Answer Posted / 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 |
Post New Answer View All Answers
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What are the approaches used by optimizer during execution plan?
What is the purpose of Dataware Control?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain bus schema?
Explain the data type of the surrogate key?
What is the difference between olap and datawarehosue?
What are the steps involved in designing a fact table?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Can a dimension table contain numeric values?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the difference between a primary and secondary actor in use case modeling?
What is the limit to the number of sources and targets you can have in a mapping?
What are the mapping paramaters and maping variables?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?