Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16323 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 steps we have to follow in designing the userfriendly universe?
Why we use repository connectivity?
How do you define data block size?
How to design file watch jobs?
What is is a star schema?
Explain difference between view and materialized view?
What is the purpose of Dataware Control?
Explain what are the tasks that loadmanger process will do?
What is the difference between ods and oltp?
What are the types of partitioning?
What is the differences between star and snowflake schemas?
Explain why should you put your data warehouse on a different system than your oltp system?
What is index awareness in universe?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain if a flat file cotains 1000 records how can I get first and last records only?
