Results of 1 - 7 of about 7 for Finds (0.005 sec.)
- Aggregate Functions – DuckDB 13450
- 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
...trary(arg) Returns the first value (null or non-null) from arg . This function is affected by ordering . arg_max(arg, val) Finds the row with the maximum val and calculates the arg expression at that row. Rows where the value of the arg or val express...g expressions for the top n rows ordered by val descending. This function is affected by ordering . arg_max_null(arg, val) Finds the row with the maximum val and calculates the arg expression at that row. Rows where the val expression evaluates to NUL...L are ignored. This function is affected by ordering . arg_min(arg, val) Finds the row with the minimum val and calculates the arg expression at that row. Rows where the value of the arg or val express... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Pattern Matching – DuckDB 8942
- 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
...ile with filename in top-level directory. For example, with a README.md file present in the directory, the following query finds it: SELECT * FROM glob ( 'README.md' ); file README.md However, the following query returns an empty result: SELECT * FROM...glob ( '**/README.md' ); Meanwhile, the globbing of Bash, Zsh, etc. finds the file using the same syntax: ls ** /README.md README.md Regular Expressions DuckDB's regular expression support is docu... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Regular Expressions – DuckDB 8778
- 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
...returns a struct with the same keys and empty strings as values. regexp_extract_all(string, regex[, group = 0][, options]) Finds non-overlapping occurrences of regex in string and returns the corresponding values of group . regexp_full_match(string, r..., 'm', 'd']) Result {'y':'2023', 'm':'04', 'd':'15'} regexp_extract_all(string, regex[, group = 0][, options]) Description Finds non-overlapping occurrences of regex in string and returns the corresponding values of group . A set of optional options c... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Relational API – DuckDB 8288
- 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
...The functions are lazy evaluated . Name Description any_value Returns the first non-null value from a given column arg_max Finds the row with the maximum value for a value column and returns the value of that row for an argument column arg_min Finds t...ups : str = '' , window_spec : str = '' , projected_columns : str = '' ) -> duckdb . duckdb . DuckDBPyRelation Description Finds the row with the maximum value for a value column and returns the value of that row for an argument column Parameters arg_...ups : str = '' , window_spec : str = '' , projected_columns : str = '' ) -> duckdb . duckdb . DuckDBPyRelation Description Finds the row with the minimum value for a value column and returns the value of that row for an argument column Parameters arg_... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- sqllogictest Introduction – DuckDB 8142
- 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
...these queries are identical. Query verification is very useful because it not only discovers bugs in optimizers, but also finds bugs in e.g., join implementations. This is because the unoptimized version will typically run using cross products instea... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Python Client API – DuckDB 7979
- 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
...umn : str , groups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → duckdb.duckdb.DuckDBPyRelation ¶ Finds the row with the maximum value for a value column and returns the value of that row for an argument column Detailed exampl...umn : str , groups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → duckdb.duckdb.DuckDBPyRelation ¶ Finds the row with the minimum value for a value column and returns the value of that row for an argument column Detailed exampl... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Text Functions – DuckDB 7979
- 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
...empty strings as values. A set of optional regex options can be set. regexp_extract_all(string, regex[, group][, options]) Finds non-overlapping occurrences of the regex in the string and returns the corresponding values of the capturing group . A set...me'], 'i') Result {'first_name': John, 'last_name': Doe} regexp_extract_all(string, regex[, group][, options]) Description Finds non-overlapping occurrences of the regex in the string and returns the corresponding values of the capturing group . A set... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work