Anton Zhiyanov
SQL Window Functions

SQL Window Functions Book
Learn how to create great analytical reports without using Excel or Pandas. A clear and visual guide to window functions in SQL.

Learn more   Other books

Featured blog posts

I mostly blog about programming and data.

latest post
High-precision date/time in SQLite

Projects

Things I'm working on. Production-ready!

codapi  go js

Interactive code examples for documentation, education and fun.

Try X in Y minutes  js

Live code tutorials in your browser. Community-driven!

redka  go

Redis re-implemented with SQLite.

sqlean  c

The ultimate set of SQLite extensions.

sqlpkg  go js

SQLite extension hub and package manager.

pokitoki  python

A Telegram chat bot built using the ChatGPT language model.

Books

Practical guides with clear explanations and interactive examples.

About

Hi, I'm Anton. I work on open source and write about programming.

GitHub Twitter Subscribe