Getting Crazy with Analytic Functions and Group By

This topic has been sitting in my backlog for a long time and I finally decided to write it. Analytic functions are not so new anymore (they’ve been around since Oracle 8i), but they are still a very powerful tool.

This is based on a real case I had quite a few years ago. A client came to me with a question regarding a graph they had to generate.

Continue reading “Getting Crazy with Analytic Functions and Group By”