Results of 1 - 10 of about 140 for First (0.005 sec.)
- FILTER Clause – DuckDB 11690
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ng a FILTER clause will return valid results when at times the CASE WHEN approach will not. This occurs with the functions first and last , which are desirable in a non-aggregating pivot operation where the goal is to simply re-orient the data into co...namically generated in a host programming language to leverage DuckDB's SQL engine for rapid, larger than memory pivoting. First generate an example dataset: CREATE TEMP TABLE stacked_data AS SELECT i , CASE WHEN i <= rows * 0.25 THEN 2022 WHEN i <= r...r, the CASE WHEN approach will not work as expected when using an aggregate function that does not ignore NULL values. The first function falls into this category, so FILTER is preferred in this case. “Pivot” the data out by year (move each year out t... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/filter.html
- FROM and JOIN Clauses – DuckDB 10462
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...are joined together using JOIN clauses, or another SELECT query inside a subquery node. DuckDB also has an optional FROM -first syntax which enables you to also query without a SELECT statement. Examples Select all columns from the table called table..._name : SELECT * FROM table_name ; Select all columns from the table using the FROM -first syntax: FROM table_name SELECT * ; Select all columns using the FROM -first syntax and omitting the SELECT clause: FROM ta...schema schema_name : SELECT * FROM schema_name .table_name ; Select the column i from the table function range , where the first column of the range function is renamed to i : SELECT t.i FROM range ( 100 ) AS t ( i ); Select all columns from the CSV f... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- Excel Import – DuckDB 10379
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...cifying the name of the Excel worksheet: SELECT * FROM read_xlsx ( 'test_excel.xlsx' , sheet = 'Sheet1' ); By default, the first sheet is loaded if no sheet is specified. Importing a Specific Range To select a specific range of cells, use the range pa...ttom-right cell: SELECT * FROM read_xlsx ( 'test_excel.xlsx' , range = 'A1:B2' ); This can also be used to, e.g., skip the first 5 of rows: SELECT * FROM read_xlsx ( 'test_excel.xlsx' , range = 'A5:Z' ); Or skip the first 5 columns SELECT * FROM read_...' ); If no range parameter is provided, the range is automatically inferred as the rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. By default, if no range is provided... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_import.html
- Excel Extension – DuckDB 10295
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rt and Excel Export pages for instructions. Installing and Loading The excel extension will be transparently autoloaded on first use from the official extension repository. If you would like to install and load it manually, run: INSTALL excel ; LOAD e...named parameters are supported. Option Type Default Description header BOOLEAN automatically inferred Whether to treat the first row as containing the names of the resulting columns. sheet VARCHAR automatically inferred The name of the sheet in the xl...sx file to read. Default is the first sheet. all_varchar BOOLEAN false Whether to read all cells as containing VARCHAR s. ignore_errors BOOLEAN false Whether to... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- Text Functions – DuckDB 9318
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...conventions . Negative values are accepted. ascii(string) Returns an integer that represents the Unicode code point of the first character of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to w...scape_character is used to search for wildcard characters in the string . instr(string, search_string) Returns location of first occurrence of search_string in string , counting from 1. Returns 0 if no match found. lcase(string) Converts string to low...to search for wildcard characters in the string . ord(string) Returns an INTEGER representing the unicode codepoint of the first character in the string . parse_dirname(path[, separator]) Returns the top-level directory name from the given path . sepa... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Aggregate Functions – DuckDB 9235
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...regions in order of the amount column: SELECT list ( region ORDER BY amount DESC ) FROM sales ; Returns the amount of the first sale using the first() aggregate function: SELECT first ( amount ORDER BY date ASC ) FROM sales ; Syntax Aggregates are fu...carded. However, there are some order-sensitive aggregates that can have non-deterministic results without ordering, e.g., first , last , list and string_agg / group_concat / listagg . These can be made deterministic by ordering the arguments. For exa...tbl ; countdown 3, 2, 1 Handling NULL Values All general aggregate functions ignore NULL s, except for list ( array_agg ), first ( arbitrary ) and last . To exclude NULL s from list , you can use a FILTER clause . To ignore NULL s from first , you can... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Enum Functions – DuckDB 9235
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...and not on its value. Name Description enum_code(enum_value) Returns the numeric value backing the given enum value. enum_first(enum) Returns the first value of the input enum type. enum_last(enum) Returns the last value of the input enum type. enum_..._value) Description Returns the numeric value backing the given enum value. Example enum_code('happy'::mood) Result 2 enum_first(enum) Description Returns the first value of the input enum type. Example enum_first(NULL::mood) Result sad enum_last(enum...iption Returns the range between the two given enum values as an array. The values must be of the same enum type. When the first parameter is NULL , the result starts with the first value of the enum type. When the second parameter is NULL , the resul... - https://man.mtool.work/duckdb/1.3/sql/functions/enum.html
- Bitstring Functions – DuckDB 8985
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e bitstring. bit_length(bitstring) Returns the number of bits in the bitstring. bit_position(substring, bitstring) Returns first starting index of the specified substring within bits, or zero if it's not present. The first (leftmost) bit is indexed 1....ring, length) Returns a bitstring of determined length. get_bit(bitstring, index) Extracts the nth bit from bitstring; the first (leftmost) bit is indexed 0. length(bitstring) Alias for bit_length . octet_length(bitstring) Returns the number of bytes...in the bitstring. set_bit(bitstring, index, new_value) Sets the nth bit in bitstring to newvalue; the first (leftmost) bit is indexed 0. Returns a new bitstring. bit_count(bitstring) Description Returns the number of set bits in t... - https://man.mtool.work/duckdb/1.3/sql/functions/bitstring.html
- Window Functions – DuckDB 8496
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rent row) / total partition rows. dense_rank() The rank of the current row without gaps; this function counts peer groups. first_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the row that is the first row (with a non-null va...the current row without gaps . rank([ORDER BY ordering]) The rank of the current row with gaps; same as row_number of its first peer. row_number([ORDER BY ordering]) The number of the current row within the partition, counting from 1. cume_dist([ORDE...e current row without gaps; this function counts peer groups. Return type BIGINT Example dense_rank() Aliases rank_dense() first_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Description Returns expr evaluated at the row that is the first row (with a... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- List Functions – DuckDB 8091
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...eature. array_pop_back(list) Returns the list without the last element. array_pop_front(list) Returns the list without the first element. flatten(list_of_lists) Concatenate a list of lists into a single list. This only flattens one level of the list (...function name on the elements of list . See the List Aggregates section for more details. list_any_value(list) Returns the first non-null value in the list. list_append(list, element) Appends element to list . list_concat(list1, ..., listn) Concatenat...st element. Example array_pop_back([4, 5, 6]) Result [4, 5] array_pop_front(list) Description Returns the list without the first element. Example array_pop_front([4, 5, 6]) Result [5, 6] flatten(list_of_lists) Description Concatenate a list of lists i... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
DuckDB 1.3 Documentation / man.mtool.work