Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16453 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
Explain the difference between oltp and olap?
Explain what are the various transformation available?
Explain can report net connect multiple datasource at a time in report creation time?
What is the difference between metadata and data dictionary?
What is the purpose of Dataware Control?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is data analytics in simple terms?
Explain dimension table ?
What are Aggregate tables?
What does level of granularity of a fact table signify?
Explain what is type 2 version dimension?
How can you set the session management?
How to design file watch jobs?
How can we load the time dimension?
What is Discover and Execute in XMLA?
