SQL Aggregate vs Aggregate Window Functions

preview_player
Показать описание
In this video, we compare SQL aggregate and aggregate window functions using DuckDB.

#duckdb #sql #dataengineering

Resources ▼

Timings ▼
00:00:27 An aggregate query
00:01:06 Aggregate window queries
00:02:08 Filtering on aggregate window queries
00:04:20 Framing
00:04:38 Row Framing
00:05:59 Range Framing
Рекомендации по теме
Комментарии
Автор

I really enjoy the way you try and use different datasets every time - nice touch!

Bump
Автор

Do you happen to know if window functions are actually supported in the Python API? I can't seem to find much about it in the docs.

jarandaf
welcome to shbcf.ru