Windowing Functions are new to MySQL with Version 8. I have
been very lucky in the past few days to find two excellent
resources that I want to share with you. Both are worth the
time and effort to study.
At the Southern California Linux Expo last week, Bruce Momjian of
EnterpriseDB and PostgreSQL fame gave an amazing tutorial on
Common Table Expressions and Windowing Functions (slides for both
at https://momjian.us/main/presentations/sql.html).
Bruce is an amazing presenter and I highly recommend going to his
sessions at conferences. So, what can a MySQL-er learn from a
Postrgrestian?
Plenty.
In this case the two databases are using SQL and the features
that turn that language from descriptive to imperative. But
showing how these features is very hard. Bruce said it took
him six years to finish …
Showing entries 1 to 1
Mar
13
2018
Showing entries 1 to 1