Results of 1 - 10 of about 27 for appear (0.002 sec.)
- CREATE MACRO Statement 15832
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...id SQL identifier. A macro may be explicitly qualified with an existing database schema. If a schema is specified, then it appears in the usual way: before the name, with a dot separating schema name and macro name. When not explicitly specified, the m...s followed by parentheses. If the macro has parameters , then they must be declared within the parentheses. The AS keyword appears after the right parenthesis but before the expression The TABLE keyword may appear right after the AS keyword, directly b...ement, or a call to another table function. Declaring Parameters Macros may declare parameters. The parameter declarations appear as a comma-separated list between the parentheses before the AS keyword. The simplified syntax for a single parameter decl... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Excel Export 10237
- DuckDB supports exporting data to Excel .xlsx files via the excel extension. Please note that .xls files are not supported. To install and load the extension, run: INSTALL excel; LOAD excel; Exporting Excel Sheets To export a table to an Ex
...since 1900-01-01 for dates and the fraction of a day for times. These are then styled with a "number format" so that they appear as dates or times when opened in Excel. TIMESTAMP_TZ and TIME_TZ are cast to UTC TIMESTAMP and TIME respectively, with the...timezone information being lost. BOOLEAN s are converted to 1 and 0 , with a "number format" applied to make them appear as TRUE and FALSE in Excel. All other types are cast to VARCHAR and then written as text cells. But you can of course also... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
- Excel Extension 8887
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...since 1900-01-01 for dates and the fraction of a day for times. These are then styled with a "number format" so that they appear as dates or times when opened in Excel. TIMESTAMP_TZ and TIME_TZ are cast to UTC TIMESTAMP and TIME respectively, with the...timezone information being lost. BOOLEAN s are converted to 1 and 0 , with a "number format" applied to make them appear as TRUE and FALSE in Excel. All other types are cast to VARCHAR and then written as text cells.... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- AsOf Join 8887
- What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay between cause and effect. This can make connecting two sets of ordered data challenging. AsOf joins are a tool for s
...efined by looking up nearby values in the prices table. Note also that missing ticker values do not have a match and don't appear in the output. Outer AsOf Joins Because AsOf produces at most one match from the right hand side, the left side table will...ticker, "when"); You will get back only the columns h.ticker, h.when, h.shares, p.price . The columns ticker and when will appear only once, with ticker and when coming from the left table (holdings). This behavior is fine for the ticker column because... - https://man.mtool.work/duckdb/2.0/guides/sql_features/asof_join.html
- Subqueries 8887
- 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
... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- FROM and JOIN Clauses 8722
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...ches can still 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... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- Aggregate Functions 8541
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
.... A boundary at the largest value of the datatype is automatically added when elements larger than all provided boundaries appear, see is_histogram_other_bin . Boundaries may be provided, e.g., via equi_width_bins . histogram_exact(arg, elements) Retur...s and their counts. A catch-all element specific to the data-type is automatically added to count other elements when they appear, see is_histogram_other_bin . histogram_values(source, col_name, technique, bin_count) A table macro (not an aggregate fun.... A boundary at the largest value of the datatype is automatically added when elements larger than all provided boundaries appear, see is_histogram_other_bin . Boundaries may be provided, e.g., via equi_width_bins . | | Example | histogram(A, [0, 1, 10... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Unnesting 8541
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...Since DuckDB 2.0, unnest can be used in the GROUP BY clause . When applied to values of the LIST -type, unnest() may also appear in clauses where one could normally use a table function . Unnesting LIST -Typed Values To fully understand unnesting LIST...all to unnest on a value of the LIST -type yields a rowset, it may also be treated as a table function . This means it may appear in the FROM -clause or a CALL -statement . Calls to unnest() in a FROM -clause or CALL -statement do not accept additional... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- JSON Processing Functions 7867
- 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
...) Return the minimal RFC 7396 merge patch such that json_merge_patch(json_orig, patch) equals json_modified . Deleted keys appear as null , changed and added keys appear with their new values, and unchanged keys are omitted. Nested objects are diffed r... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
- Result Verification 7867
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...e individual values separated by tabs, or in value-wise order. In value wise order the individual values of the query must appear in row, column order each on an individual line. Consider the following example in both row-wise and value-wise order: # r... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
DuckDB 2.0 Documentation / man.mtool.work