Results of 1 - 10 of about 24 for least (0.009 sec.)
- Numeric Functions – DuckDB 15579
- 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
...actorial of x 4! 24 Division and Modulo Operators There are two division operators: / and // . They are equivalent when at least one of the operands is a FLOAT or a DOUBLE . When both operands are integers, / performs floating points division ( 5 / 2...alse otherwise. isnan(x) Returns true if the floating point value is not a number, false otherwise. lcm(x, y) Computes the least common multiple of x and y . least_common_multiple(x, y) Computes the least common multiple of x and y . least(x1, x2, ......g point value is not a number, false otherwise. Example isnan('NaN'::float) Result true lcm(x, y) Description Computes the least common multiple of x and y . Example lcm(42, 57) Result 798 least_common_multiple(x, y) Description Computes the least com... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- FROM and JOIN Clauses – DuckDB 10175
- 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
...till be returned if an OUTER join is specified. Outer joins can be one of: LEFT (All rows from the left relation appear at least once) RIGHT (All rows from the right relation appear at least once) FULL (All rows from both relations appear at least onc...ity_airport JOIN airport_names USING ( iata ); Semi and Anti Joins Semi joins return rows from the left table that have at least one match in the right table. Anti joins return rows from the left table that have no matches in the right table. When usi...T t . * , p.price FROM trades t ASOF JOIN prices p ON t.symbol = p.symbol AND t.when >= p.when ; The ASOF join requires at least one inequality condition on the ordering field. The inequality can be any inequality condition ( >= , > , <= , < ) on any... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- Numeric Types – DuckDB 9140
- 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
...point series on Bruce Dawson's blog provide excellent starting points. On most platforms, the FLOAT type has a range of at least 1E-37 to 1E+37 with a precision of at least 6 decimal digits. The DOUBLE type typically has a range of around 1E-307 to 1E...+308 with a precision of at least 15 digits. Positive numbers outside of these ranges (and negative numbers ourside the mirrored ranges) may cause errors on... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Date Functions – DuckDB 9140
- 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
...ulian(date) Extract the Julian Day number from a date. last_day(date) The last day of the corresponding month in the date. least(date, date) The earlier of two dates. make_date(year, month, day) The date for the given parts. monthname(date) The (Engli...te) Description The last day of the corresponding month in the date. Example last_day(DATE '1992-09-20') Result 1992-09-30 least(date, date) Description The earlier of two dates. Example least(DATE '1992-09-20', DATE '1992-03-07') Result 1992-03-07 ma... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Literal Types – DuckDB 8607
- 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
...licit String Literal Concatenation Consecutive single-quoted string literals separated only by whitespace that contains at least one newline are implicitly concatenated: SELECT 'Hello' ' ' 'World' AS greeting ; is equivalent to: SELECT 'Hello' || ' '...g ; They both return the following result: greeting Hello World Note that implicit concatenation only works if there is at least one newline between the literals. Using adjacent string literals separated by whitespace without a newline results in a sy... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Timestamp Functions – DuckDB 8607
- 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
...therwise. julian(timestamp) Extract the Julian Day number from a timestamp. last_day(timestamp) The last day of the month. least(timestamp, timestamp) The earlier of two timestamps. make_timestamp(bigint, bigint, bigint, bigint, bigint, double) The ti...timestamp) Description The last day of the month. Example last_day(TIMESTAMP '1992-03-22 01:02:03.1234') Result 1992-03-31 least(timestamp, timestamp) Description The earlier of two timestamps. Example least(TIMESTAMP '1992-09-20 20:38:48', TIMESTAMP... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 8440
- 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
...is finite, false otherwise. isinf(timestamptz) Returns true if the timestamp with time zone is infinite, false otherwise. least(timestamptz, timestamptz) The earlier of two timestamps. now() Current date and time (start of current transaction). timet...urns true if the timestamp with time zone is infinite, false otherwise. Example isinf(TIMESTAMPTZ '-infinity') Result true least(timestamptz, timestamptz) Description The earlier of two timestamps. Example least(TIMESTAMPTZ '1992-09-20 20:38:48', TIME... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Node.js Client (Neo) – DuckDB 8273
- 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
...t_all_types() ' ); const rows = reader . getRows (); // OR: const columns = reader.getColumns(); Stream and read up to (at least) some number of rows: const reader = await connection . streamAndReadUntil ( ' from range(5000) ' , 1000 ); const rows = r...st reader = await connection . runAndReadAll ( sql , values , types ); // Run to completion, wrap in a reader, and read at least // the given number of rows. (Rows are read in chunks, so more than // the target may be read.) const reader = await conne...await connection . streamAndReadAll ( sql , values , types ); // Create a streaming result, wrap in a reader, and read at least // the given number of rows. const reader = await connection . streamAndReadUntil ( sql , targetRowCount ); const reader =... - https://man.mtool.work/duckdb/1.3/clients/node_neo/overview.html
- Text Functions – DuckDB 8273
- 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
...ce of search_string in string , counting from 1. Returns 0 if no match found. lcase(string) Converts string to lower case. least(arg1, ...) Returns the smallest value in lexicographical order. Note that uppercase characters are considered smaller than...position , strpos lcase(string) Description Converts string to lower case. Example lcase('Hello') Result hello Alias lower least(arg1, ...) Description Returns the smallest value in lexicographical order. Note that uppercase characters are considered...smaller than lowercase characters and collations are not supported. Example 1 least(42, 84) Result 42 Example 2 least('abc', 'bcd', 'cde', 'EFG') Result EFG left(string, count) Description Extracts the left... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Struct Data Type – DuckDB 8090
- 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' ); Invalid Input Error: A table cannot be created from an unnamed struct When casting between structs, the names of at least one field have to match. Therefore, the following query will fail: SELECT a :: STRUCT ( y INTEGER ) AS b FROM ( SELECT { '...x' : 42 } AS a ); Binder Error: STRUCT to STRUCT cast must have at least one matching member A workaround for this is to use struct_pack instead: SELECT struct_pack ( y : = a.x ) AS b FROM ( SELE... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
DuckDB 1.3 Documentation / man.mtool.work