Results of 1 - 4 of about 4 for spreadsheet (0.001 sec.)
- PIVOT Statement 12408
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...atement. Simplified PIVOT Syntax The full syntax diagram is below, but the simplified PIVOT syntax can be summarized using spreadsheet pivot table naming conventions as: PIVOT ⟨dataset⟩ ON ⟨columns⟩ USING ⟨values⟩ GROUP BY ⟨rows⟩ ORDER BY ⟨columns_with_orde...ch. The ON clause specifies which column(s) to split into separate columns. It is equivalent to the columns parameter in a spreadsheet pivot table. The USING clause determines how to aggregate the values that are split into separate columns. This is equival...ent to the values parameter in a spreadsheet pivot table. If the USING clause is not included, it defaults to count(*) . PIVOT cities ON year USING sum(population); co... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- Dot Commands 8525
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...query. \e can be used as an alias. See the external editor mode section .excel Display the output of the next command in a spreadsheet. Equivalent to .once -x .exit ⟨CODE⟩ Exit this program with return-code CODE .headers ⟨on/off⟩ Turn display of headers on...ther the -e flag for a text file (opened in the default text editor), or the -x flag for a CSV file (opened in the default spreadsheet editor). This is useful for more detailed inspection of query results, especially if there is a relatively large result se... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Excel Extension 8099
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...o the corresponding inferred column type with NULL 's. range VARCHAR automatically inferred The range of cells to read, in spreadsheet notation. For example, A1:B2 reads the cells from A1 to B2. If not specified the resulting range will be inferred as recta... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- UNPIVOT Statement 7896
- 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
...ent. Simplified UNPIVOT Syntax The full syntax diagram is below, but the simplified UNPIVOT syntax can be summarized using spreadsheet pivot table naming conventions as: UNPIVOT ⟨dataset⟩ ON ⟨column(s)⟩ INTO NAME ⟨name_column_name⟩ VALUE ⟨value_column_name(... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work