Results of 1 - 10 of about 10 for wrapped (0.001 sec.)
- GROUP BY Clause 13247
- The GROUP BY clause specifies which grouping columns should be used to perform any aggregations in the SELECT clause. If the GROUP BY clause is specified, the query is always an aggregate query, even if no aggregations are present in the SE
...ch as count , sum , avg , etc). GROUP BY ALL Use GROUP BY ALL to GROUP BY all columns in the SELECT statement that are not wrapped in aggregate functions. This simplifies the syntax by allowing the columns list to be maintained in a single location, and...SELECT city, street_name FROM addresses GROUP BY ALL; Compute the average income per city per street_name. Since income is wrapped in an aggregate function, do not include it in the GROUP BY : SELECT city, street_name, avg(income) FROM addresses GROUP B... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/groupby.html
- INSERT Statements 10315
- INSERT statements are the standard way of loading data into a relational database. When using INSERT statements, the values are supplied row-by-row. While simple, there is significant overhead involved in parsing and processing individual I
...is required to sync the changes made to disk to ensure no data is lost. In auto-commit mode every single statement will be wrapped in a separate transaction, meaning fsync will be called for every statement. This is typically unnecessary when bulk loadi... - https://man.mtool.work/duckdb/2.0/data/insert.html
- TRY Expression 10315
- The TRY expression ensures that errors caused by the input rows in the child (scalar) expression result in NULL for those rows, instead of causing the query to throw an error. The TRY expression was inspired by the TRY_CAST expression . Exa
...mples The following calls return errors when invoked without the TRY expression. When they are wrapped into a TRY expression, they return NULL : Casting Without TRY SELECT 'abc'::INTEGER; Conversion Error: Could not convert s... - https://man.mtool.work/duckdb/2.0/sql/expressions/try.html
- Map Type 8849
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...key1': 5, 'key2': 43}['key3']; NULL The map_extract function (and its synonym element_at ) can be used to retrieve a value wrapped in a list; it returns an empty list if the key is not contained in the map: SELECT map_extract(MAP {'key1': 5, 'key2': 43}... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Troubleshoot 8491
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...etadata, or regenerate the metadata with the tracing agent against the exact driver version in use. The error is sometimes wrapped in a misleading message: java.lang.UnsatisfiedLinkError: Unsupported JNI version 0xffffffff, required by ⟨path⟩/libduckdb_... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Subqueries 8134
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...WHERE grade = (SELECT min(grade) FROM grades); course Math ARRAY Subqueries Subqueries that return multiple values can be wrapped with ARRAY to collect all results in a list. SELECT ARRAY(SELECT grade FROM grades) AS all_grades; all_grades [7, 9, 8] Su... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- PIVOT Statement 7758
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...ON year USING sum(population) GROUP BY country ) SELECT * FROM pivot_alias; A PIVOT may be used in a subquery and must be wrapped in parentheses. Note that this behavior is different than the SQL Standard Pivot, as illustrated in subsequent examples. S... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- UNPIVOT Statement 7758
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...(empid, dept)) INTO NAME month VALUE sales ) SELECT * FROM unpivot_alias; An UNPIVOT may be used in a subquery and must be wrapped in parentheses. Note that this behavior is different than the SQL Standard Unpivot, as illustrated in subsequent examples.... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- Instantiate 7401
- Overview DuckDB-Wasm can be instantiated in several ways, depending on how your application bundles and serves its assets. Each approach resolves the mainModule (the WebAssembly file) and the mainWorker (the worker script) for the browser's
...electBundle picks the one that matches the browser. Because a Web Worker script must be same-origin, the CDN worker URL is wrapped in a Blob that importScripts it, and the temporary object URL is revoked once the worker has started. import * as duckdb f... - https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
- JSON Processing Functions 7025
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...ck . Both parameters are of JSON type, but json_needle can also be a numeric value or a string, however the string must be wrapped in double quotes. json_keys(json[, path]) Returns the keys of json as a LIST of VARCHAR , if json is a JSON object. If pat... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work