SQL Aggregate vs Aggregate Window Functions
In this video, we compare SQL aggregate and aggregate window functions using DuckDB.
#duckdb #sql #dataengineering
Resources ▼
▶ Citi bikes dataset - https://www.kaggle.com/datasets/rosen...
▶ DuckDB window functions - https://duckdb.org/docs/sql/window_fu...
▶ Queries used in the video - https://gist.github.com/mneedham/84ff...
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
On this page of the site you can watch the video online SQL Aggregate vs Aggregate Window Functions with a duration of hours minute second in good quality, which was uploaded by the user Learn Data with Mark 01 January 1970, share the link with friends and acquaintances, this video has already been watched 1,153 times on youtube and it was liked by 30 viewers. Enjoy your viewing!
