Why you should definitely learn SQL Window Functions

Introduction

I found this question on the Hibernate forum, and it’s a very good opportunity to show why mastering Windows Functions is a very important skill for any backend software developer.

Continue reading “Why you should definitely learn SQL Window Functions”

Advertisements

Time to break free from the SQL-92 mindset

Are you stuck in the 90s?

If you are only using the SQL-92 language reference, then you are overlooking so many great features like:

Some test data

In my previous article I imported some CSV Codahale metrics into PostgreSQL for further analysis.

Continue reading “Time to break free from the SQL-92 mindset”