SQL Window Functions

2 years ago 1 min read

Have you had someone ask you to run a report with so many details that it made you want to jump out a window? Rock has the ability to aggregate tons of data into all kinds of reporting - you just have to speak the right language. With SQL, the language behind Rock's database, you can utilize the raw data in Rock to create reports that will make any detail lover happy.

In the newest Triumph strategy video, Jon shows us how to use Window Functions with aggregates, ranks and LAG to make complex reports much more manageable. You don’t have to jump out the window when you can use Window Functions!

Click here to watch.

Let’s get to work

Ready to bring your Rock RMS ideas to life?

We’re here to help.

Contact Us