SQL Window Functions Explained
Window functions are probably the most confusing part of SQL. You might think, "So what? They just added a few extra functions". Not really. "Window functions" is a separate language built into regular SQL. And it's more complicated than anything you know about SELECTs. I've read several dozen articles explaining SQL window functions. They all suffered from one of two problems: (1) Easy read without much practical value, describing 10% of features, or (2) Difficult to comprehend (if I did not know the subject — I would not understand a thing). I wanted people to understand SQL windows…
What it does
In the maker’s words, at launch
Window functions are probably the most confusing part of SQL. You might think, "So what? They just added a few extra functions". Not really. "Window functions" is a separate language built into regular SQL. And it's more complicated than anything you know about SELECTs. I've read several dozen articles explaining SQL window functions. They all suffered from one of two problems: (1) Easy read without much practical value, describing 10% of features, or (2) Difficult to comprehend (if I did not know the subject — I would not understand a thing). I wanted people to understand SQL windows better. So I wrote a book on window functions with a hundred pictures and GIFs explaining everything, and fifty-six interactive exercises to turn abstract knowledge into skills. Here it is.
Does the same job
all alternatives →
- SQSQLite query inside a Bash function2021 · ▲134
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
- TETranslate English to SQL2019 · github.com · ▲209
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, October 2023
the whole month →
Nudge 2.0▲1,051In-app experiences to activate, retain, & understand users
Growth · 2023 · nudgenow.com
Unlock AI magic for elevated customer engagement, fast
AI · 2023 · tiledesk.com
- OD
Effortlessly discover API behaviour with a Chrome extension that automatically generates OpenAPI specifications in real time for any app or website.
Dev tools · 2023 · github.com