Exploring Common Table Expressions and Window Functions
Talk by Bruce Momjian
Developers are often challenged to deliver results that are hard to implement using simple SQL queries. Fortunately, complex SQL capabilities exist in the SQL standards. Common table expressions allow for imperative control of query results, while window functions allow row results to reference values in other rows of the data set. This tutorial shows how to use both of these SQL features to generate complex data results.
More info at: https://www.socallinuxexpo.org/scale/...