{size:14}
Is there any way that I can make the following query as I meant?
{size}
SELECT RNK,
FIRST,
SECOND
FROM (
SELECT 1 RNK FROM DUAL
UNION ALL
SELECT 2 RNK FROM DUAL
)
MODEL
DIMENSION BY ( RNK )
MEASURES (
0 FIRST,
0 SECOND
)
RULES (
FIRST[1] = 1,
FIRST[RNK > 1] = SECOND[CV(RNK) - 1] + 1,
SECOND[ANY] = FIRST[CV()] + 2
)
{size:14}
I wish to make the result something like following.
{size}
RNK FIRST SECOND
---------- ---------- ----------
1 1 3
2 4 6
{size:14}
Any suggestion?
Thanks in advance.
{size}