Results of 1 - 10 of about 12 for greater (0.003 sec.)
- Comparisons – DuckDB 14610
- 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
...ut arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than 2 > 3 false <= less than or equal to 2 <= 3 true >= greater than or equal to 4 >= NULL NULL = or == equal NULL = NULL...tors equal expression standard comparison below type table Description These DuckDB equivalent shows Operator Example less greater including Combination Casting casts PostgreSQL stricter checking otherwise 関連するページ Caveats TRY expression Expressio... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Array Type – 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
...y WHERE x.i = y.i ; Ordering The ordering of ARRAY instances is defined using a lexicographical order. NULL values compare greater than all other values and are considered equal to each other. See Also For more functions, see List Functions . 関連キーワ... - https://man.mtool.work/duckdb/1.3/sql/data_types/array.html
- sqllogictest Introduction – DuckDB 8543
- 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
...or size. For example, adding require vector_size 512 to a test will prevent the test from being run unless the vector size greater than or equal to 512. This is useful because certain functionality is not supported for low vector sizes, but we run tests... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Map Type – DuckDB 8543
- 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
...lues . The ordering is defined positionally in the same way that words can be ordered in a dictionary. NULL values compare greater than all other values and are considered equal to each other. At the top level, NULL nested values obey standard SQL NULL... - https://man.mtool.work/duckdb/1.3/sql/data_types/map.html
- Subqueries – DuckDB 8543
- 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 following query SELECT 8 >= ALL ( SELECT grade FROM grades ) AS excellent ; returns excellent false because 8 is not greater than or equal to the subquery result 7. And thus, because not all comparisons evaluate true , >= ALL as a whole evaluates... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
- Date Format Functions – DuckDB 8543
- 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
...a decimal number, zero-padded on the left. 000 - 999 %G ISO 8601 year with century representing the year that contains the greater part of the ISO week (see %V ). 0001, 0002, …, 2013, 2014, …, 9998, 9999 %H Hour (24-hour clock) as a zero-padded decimal... - https://man.mtool.work/duckdb/1.3/sql/functions/dateformat.html
- Profiling – DuckDB 8118
- 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
...ime spent in other stages, like parsing, query planning, etc. Thus, for some queries, the LATENCY in the QUERY_ROOT can be greater than the CPU_TIME . Detailed Profiling When the profiling_mode is set to detailed , an extra set of metrics are enabled, w... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- Numeric Types – DuckDB 8118
- 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
...ckDB follows the IEEE 754 specification regarding these special values, with two exceptions: NaN compares equal to NaN and greater than any other floating point number. Some floating point functions, like sqrt / sin / asin throw errors rather than retur... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Lambda Functions – DuckDB 8118
- 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
...list elements: SELECT list_reduce ([ 1 , 2 , 3 , 4 ], lambda acc , x : acc + x ); 10 Only add up list elements if they are greater than 2: SELECT list_reduce ( list_filter ([ 1 , 2 , 3 , 4 ], lambda x : x > 2 ), lambda acc , x : acc + x ); 7 Concat all... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- Regular Expressions – DuckDB 8118
- 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
...names is less than the number of capture groups, then only the first groups are returned. If the number of column names is greater, then an error is generated. Limitations Regular expressions only support 9 capture groups: \1 , \2 , \3 , …, \9 . Capture... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
DuckDB 1.3 Documentation / man.mtool.work