Community

OLAP SQL Part 3 – RANK, DENSERANK, ROWNUM

(Chris Eaton) In addition to the OLAP grouping functions there are other OLAP functions that can be used to help order rows or to show ordering within a grouping. The first of these is the RANK function. Rank will display the value of the rows order within a set. So for example if I have 10 rows in

Read More - Register for Free Membership

Tags: