Group By<\/p>\n
group by attr1, attr2<\/p>\n
group by ROLLUP(attr1, attr2)<\/p>\n
group by CUBE(attr1, attr2)<\/p>\n
Rank, Dense_RANK, ROW_number:<\/p>\n
RANK() OVER (ORDER BY PRICE) as "PR",
\nROW_NUMBER() OVER (ORDER BY PRICE) as "PR"
\nDENSE_RANK() OVER (ORDER BY C DESC NULLS LAST) as "R"
\nDENSE_RANK() OVER (PARTITION by C ORDER BY P) as "PR"
\nRANK() OVER (ORDER BY P) as "PR"
\navg(C) OVER() AS "AC"
\nMIN(Y) KEEP (DENSE_RANK FIRST ORDER BY Y) as "FirstItem"
\nMIN(Y) KEEP (DENSE_RANK LAST ORDER BY Y) as "LASTItem"<\/p>\n
Hierarchical Query:<\/p>\n
START WITH employee_id = 102
\nCONNECT BY FOLLOWING m_id = e_id;<\/p>\n
Keep First or Last Row<\/p>\n
KEEP (DENSE_RANK FIRST ORDER BY \u2026)
\nKEEP (DENSE_RANK LAST ORDER BY \u2026)<\/p>\n
PARTITION BY on RANK\/Dense_Rank<\/p>\n
RANK()
\nRANK() OVER
\nRANK() OVER PARTITION BY
\nDENSE RANK() OVER
\nDENSE RANK() OVER PARTITION BY
\nPARTITION BY \u2026. ORDER BY
\nROW_NUMBER() OVER (ORDER By \u2026)
\nROWS BETWEEN Unbounded Preceding and CURRENT ROW
\nRANGE BETWEEN INTERVAL 5 DAY PRECEDING AND INTERVAL ‘5’ DAY Following
\nROWS BETWENN 1 PRECEDING and 1 FOLLOWING
\nDENSE RANK() OVER (PARTITION BY …..)
\nDENSE RANK() OVER (PARTITION BY …..ORDER BY …)<\/p>\n","protected":false},"excerpt":{"rendered":"
Group By group by attr1, attr2 group by ROLLUP(attr1, attr2) group by CUBE(attr1, attr2) Rank, Dense_RANK, ROW_number: RANK() OVER (ORDER BY PRICE) as "PR", ROW_NUMBER() OVER (ORDER BY PRICE) as "PR" DENSE_RANK() OVER (ORDER BY C DESC NULLS LAST) as "R" DENSE_RANK() OVER (PARTITION by C ORDER BY P) as "PR" RANK() OVER (ORDER BY … <\/p>\n