Results of 1 - 10 of about 14 for Round (0.002 sec.)
- Numeric Functions 14564
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...rns a HUGEINT . bit_count(x) Returns the number of bits that are set. cbrt(x) Returns the cube root of the number. ceil(x) Rounds the number up. ceiling(x) Rounds the number up. Alias of ceil . cos(x) Computes the cosine of x . cosh(x) Computes the hy...decimal arithmetic, returning a DECIMAL . degrees(x) Converts radians to degrees. divide(x, y) Alias for x // y . even(x) Round to next even number by rounding away from zero. exp(x) Computes e ** x . factorial(x) See the ! operator. Computes the pro...elow it. fdiv(x, y) Performs integer division ( x // y ) using the floored definition and returns a DOUBLE value. floor(x) Rounds the number down. fmod(x, y) Calculates the modulo value using the floored definition. Always returns a DOUBLE value. gamm... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Numeric Types 10555
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...ed. If only the WIDTH is specified, the SCALE defaults to 0 – for example, DECIMAL(18) is equivalent to DECIMAL(18, 0) and rounds to whole numbers (e.g., 1.5::DECIMAL(18) is 2 ). Specifying the WIDTH and the SCALE Both parameters are optional, and a t...trained decimal type as it is in PostgreSQL and Oracle. DuckDB always binds it to the concrete type DECIMAL(18, 3) , which rounds to 3 fractional digits and holds at most 15 digits before the decimal point. The WIDTH must be between 1 and 38, and the...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 ou... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- HTTP CSV Import 8542
- To load a CSV file directly over HTTP(S), the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL comman
...openly licensed (CC BY 4.0) real-world CSV directly over HTTP and aggregates it, with no local download step: SELECT area, round(avg(sunbed_price), 0) AS avg_sunbed_price_eur, count(*) AS clubs FROM 'http://blobs.duckdb.org/data/beach-clubs.csv' WHERE... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_csv_import.h...
- Quack Remote Protocol 8542
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...are encoded with DuckDB's internal serialization primitives (the same code path used by the Write-Ahead Log ). This avoids round-tripping data through an interchange format and keeps complex types (nested, decimals, intervals, ...) lossless across the...wire. Single round-trip per query. After the initial connection handshake, a query needs only one request–response pair. Large results stream... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Expression API 8244
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
...2) │ │ int64 │ ├────────────────┤ │ 2 │ │ 4 │ │ 6 │ │ 8 │ └────────────────┘ fn also passes keyword arguments by name: fn("round", col("x"), precision=1) is round("x", "precision" := 1) . coalesce(*values) gives the first of its arguments that is not... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Unofficial and Unsupported Platforms 8244
- Warning The platforms listed on this page are not officially supported. The build instructions are provided on a best-effort basis. Community contributions are very welcome. DuckDB is built and distributed for several platforms with differe
...ted: ./duckdb -c “CREATE TABLE test AS SELECT range AS id, range * 3.14 AS value FROM range(1000); SELECT count(*) AS cnt, round(avg(value), 2) AS avg_val FROM test;” ┌───────┬─────────┐ │ cnt │ avg_val │ │ int64 │ double │ ├───────┼─────────┤ │ 1000... - https://man.mtool.work/duckdb/2.0/dev/building/unofficial_and_unsupported_platfo...
- DuckDB Wasm Client 8157
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...the same DuckDB-Wasm library this page describes. Every query you type executes client-side in WebAssembly, with no server round-trip, so it is a live demonstration of what your own application gets when it embeds DuckDB-Wasm. Installation DuckDB-Wasm...mbly limits the amount of available memory to 4 GB and browsers may impose even stricter limits. See Troubleshoot for workarounds when you run into these limits. Further Reading Instantiate — the bundle-selection patterns for jsDelivr, webpack, Vite,...— the components a deployment serves and the security considerations involved. Troubleshoot — common issues and their workarounds, including CORS errors, memory limits, and threading. Clients Overview — the other client APIs DuckDB provides alongside... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
- Securing Quack with a Reverse Proxy 8157
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...43' AS quack ( TOKEN '⟨authentication_token-from-quack_serve⟩', DISABLE_SSL false ); FROM quack.query('SELECT 42'); If the round-trip succeeds, your traffic just went out as TLS to Caddy, got terminated, and was forwarded as plain HTTP to Quack on :94... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- SQL to/from JSON 8052
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...serialize_sql(...)) . Note that these functions do not preserve syntactic sugar such as FROM * SELECT ... , so a statement round-tripped through json_deserialize_sql(json_serialize_sql(...)) may not be identical to the original statement, but should a... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Keywords and Identifiers 8052
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
.... Backtick-quoted identifiers are never case-folded and work everywhere double-quoted identifiers do. Note that stored and round-tripped DDL (for example in [ duckdb_views()`](#duckdb_views)) still uses double quotes. Deduplicating Identifiers In some... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
DuckDB 2.0 Documentation / man.mtool.work