Build an Automated Financial Report Analyzer with DuckDB: From Raw CSV to Investment Reports in One Click
Tags
26 pages
Window Functions
DuckDB in Action: Advanced Window Functions — RANK, LAG/LEAD, FIRST/LAST_VALUE in Real Business Scenarios
The Complete Guide to Time Series Analysis with DuckDB: From MoM/YoY to User Retention
DuckDB Data Cleaning and Aggregation: From Messy CSVs to Clean Reports
DuckDB One-Trick: ROW_NUMBER() Overread Returns Wrong Numbers — And the 1-Line Fix
DuckDB Array Aggregation in Practice: Building Regional Sales Heatmaps with SQL
Completing Missing Time Series in DuckDB: generate_series + LAST_VALUE in Action
DuckDB 1.5 Window Function Macros: One-Line SQL for JSON Aggregation
DuckDB in Action: Advanced Window Functions — RANK, LAG/LEAD, FIRST/LAST_VALUE in Real Business Scenarios
The Complete Guide to DuckDB Window Functions: Say Goodbye to Subqueries
