Working with data in SQL.
JSONB has landed.
A lightweight in-process SQL OLAP engine, powered by ClickHouse.
Order by in aggregates, better string concatenation, and thorough date formatting.
Inserting and updating data with a single query.
The many faces of JOIN in SQL.
Seriously, I don't. I'd prefer SQL.
Allows executing queries without touching the table.
Calculate the difference between each record and the previous or next one.
According to the standard, we should use be using FETCH.
Assigning each record to a specific segment based on the value of one or more columns.
For those who knew SQL, but kinda forgot it.
Assigning a rank to each row based on the value of one or more columns.
Moving averages, cumulative totals and other sliding aggregates.
Comparing individual values with totals and averages.
Comparing records with neighbors and boundaries.
Making ratings and dividing data into partitions.
To build great analytical reports without Excel or Pandas.
A clear and visual introduction to window functions in SQL.
Use them instead of subqueries.
Strict tables, any type and a new pragma.
CC-licensed design guide for presentations, reports, and dashboards.