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
Where the data cube technology is used?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are the various methods of getting incremental records or delta records from the source systems?
What is the function of etl when used in data warehousing?
Explain what is type 2 version dimension?
What is the metadata extension?
Explain clustering algorithm?
ware house management system is used?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is load manager?
What is the main difference between star and snowflake star schema? Which one is better and why?
How to create different types of templates?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What is the data type of the surrogate key?
How do we design a universe?