Blog: jooq (Lukas Eder) |
|
221 blogs
updated: 44 min. ago
|
||
|
Everyone knows the SQL SUM() aggregate function (and many people also know its window function variant). When querying the Sakila database, ...
|
||
|
SQL is a verbose language, and one of the most verbose features are window functions. In a stack overflow question that I've encountered rec...
|
||
|
I recently stumbled upon a curious query on a customer's productive Oracle database: Two things caught my attention: The query was executed ...
|
||
|
I've stumbled across this fun SQL question on reddit, recently. The question was looking at a time series of data points where some events h...
|
||
|
One of the more frequent questions people have when switching from JPA to jOOQ is how to migrate from using JPA's first level cache? Speakin...
|
||
|
One of the more frequent questions people have when switching from JPA to jOOQ is how to migrate from using JPA's first level cache? Speakin...
|
||
|
Oracle is one of the few databases that implements the SQL standard ORDBMS extensions, which essentially allow for nested collections. Other...
|
||
|
One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query. The Basics Running some queri...
|
||
|
Exciting discovery when playing around with PostgreSQL 11! New SQL standard window function clauses have been supported. If you want to play...
|
||
|
Imagine you have a configuration table like the following: It specifies a set of rules that Can be enabled / disabled Can be given a priorit...
|
||