Practical SQL: OLAP, Part 2

(Joe Pluta) In my previous OLAP article, I used the OLAP function ROW_NUMBER to provide the concept of "next record" that we take for granted in RPG’s native access (contrast RPG’s native ISAM access with SQL’s relational access). In this article, I’ll show you the magic of GROUPING SETS and how the

Read More - Register for Free Membership