Results of 1 - 3 of about 3 for monthly (0.001 sec.)
- UNPIVOT Statement 11905
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...⟩ LIMIT ⟨number_of_rows⟩; Example Data All examples use the dataset produced by the queries below: CREATE OR REPLACE TABLE monthly_sales (empid INTEGER, dept TEXT, Jan INTEGER, Feb INTEGER, Mar INTEGER, Apr INTEGER, May INTEGER, Jun INTEGER); INSERT INT...O monthly_sales VALUES (1, 'electronics', 1, 2, 3, 4, 5, 6), (2, 'clothes', 10, 20, 30, 40, 50, 60), (3, 'cars', 100, 200, 300, 400,...500, 600); FROM monthly_sales; empid dept Jan Feb Mar Apr May Jun 1 electronics 1 2 3 4 5 6 2 clothes 10 20 30 40 50 60 3 cars 100 200 300 400 500... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- Dutch Railway Datasets 8203
- Examples in this documentation often use datasets based on the Dutch Railway datasets . These high-quality datasets are maintained by the team behind the Rijden de Treinen (Are the trains running?) application . This page contains download
...pressed CSVs in a single zip Yearly Datasets The yearly datasets are about 350 MB each. 2019 2020 2021 2022 2023 2024 2025 Monthly Datasets The monthly datasets are about 30 MB each. 2024-01 2024-02 2024-03 2024-04 2024-05 2024-06 2024-07 2024-08 2024-0... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- Pivot Internals 7757
- PIVOT Pivoting is implemented as a combination of SQL query re-writing and a dedicated PhysicalPivot operator for higher performance. Each PIVOT is implemented as set of aggregations into lists and then the dedicated PhysicalPivot operator
...s. If dynamically unpivoting, the COLUMNS expression is evaluated first to calculate the column list. For example: UNPIVOT monthly_sales ON jan, feb, mar, apr, may, jun INTO NAME month VALUE sales; is translated into: SELECT empid, dept, unnest(['jan',...'feb', 'mar', 'apr', 'may', 'jun']) AS month, unnest(["jan", "feb", "mar", "apr", "may", "jun"]) AS sales FROM monthly_sales; Note the single quotes to build a list of text strings to populate month , and the double quotes to pull the column... - https://man.mtool.work/duckdb/2.0/internals/pivot.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work