Results of 1 - 10 of about 25 for keyword (0.003 sec.)
- Syntax Highlighting – DuckDB 13250
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...ntirely using the .highlight off command. Below is a list of components that can be configured. Type Command Default color Keywords .keyword green Constants ad literals .constant yellow Comments .comment brightblack Errors .error red Continuation .cont...black Continuation (Selected) .cont_sel green The components can be configured using either a supported color name (e.g., .keyword red ), or by directly providing a terminal code to use for rendering (e.g., .keywordcode \033[31m ). Below is a list of su... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- AsOf Join – DuckDB 12985
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...-01-01 00:01:30 21.16 DATA 2000-12-31 23:59:30 DATA 2001-01-01 00:00:30 DATA 2001-01-01 00:01:30 AsOf Joins with the USING Keyword So far we have been explicit about specifying the conditions for AsOf, but SQL also has a simplified join condition syntax...for the common case where the column names are the same in both tables. This syntax uses the USING keyword to list the fields that should be compared for equality. AsOf also supports this syntax, but with two restrictions: The la... - https://man.mtool.work/duckdb/1.3/guides/sql_features/asof_join.html
- Time Types – DuckDB 9730
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...ores time zone) TIMETZ TIME WITH TIME ZONE Time of day (uses time zone) Instances can be created using the type names as a keyword, where the data must be formatted according to the ISO 8601 format ( hh:mm:ss[.zzzzzz][+-TT[:tt]] ). SELECT TIME '1992-09-...tation Copy Markdown specify hour minute second microsecond Aliases Description ignores uses Instances created using names keyword formatted according format 関連するページ Timestamp Issues Date Part Functions Timestamp Types Timestamp with Time Zone Fu... - https://man.mtool.work/duckdb/1.3/sql/data_types/time.html
- DuckDB_% Metadata Functions – DuckDB 9464
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...IQUE constraints are maintained using indexes, but their details are included in the duckdb_constraints() function. duckdb_keywords The duckdb_keywords() function provides metadata about DuckDB's keywords and reserved words. Column Description Type keyw...ord_name The keyword. VARCHAR keyword_category Indicates the category of the keyword. Values are column_name , reserved , type_function and unr... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- FROM and JOIN Clauses – DuckDB 9199
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...present in both tables were included in the result. We can also express query using the vanilla JOIN clause with the USING keyword: SELECT * FROM city_airport JOIN airport_names USING ( iata ); Semi and Anti Joins Semi joins return rows from the left ta...* FROM city_airport WHERE iata NOT IN ( SELECT iata FROM airport_names WHERE iata IS NOT NULL ); Lateral Joins The LATERAL keyword allows subqueries in the FROM clause to refer to previous subqueries. This feature is also known as a lateral join . SELEC... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- Keywords and Identifiers – DuckDB 8916
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...rage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / DuckDB's SQL Dialect Copy Markdown Keywords and Identifiers Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are su...bject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keywords() ), e.g., SELECT 123 AS SELECT will fail. They must not start with a number or special character, e.... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- ORDER BY Clause – DuckDB 8916
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...rary scalar expression (which could be a column name), a column position number (where the indexing starts from 1), or the keyword ALL . Each expression can optionally be followed by an order modifier ( ASC or DESC , default is ASC ), and/or a NULL orde...r modifier ( NULLS FIRST or NULLS LAST , default is NULLS LAST ). ORDER BY ALL The ALL keyword indicates that the output should be sorted by every column in order from left to right. The direction of this sort may be... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/orderby.html
- Pattern Matching – DuckDB 8651
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...c' ; -- false SELECT 'abc' LIKE 'c%' ; -- false SELECT 'abc' LIKE '%c' ; -- true SELECT 'abc' NOT LIKE '%c' ; -- false The keyword ILIKE can be used instead of LIKE to make the match case-insensitive according to the active locale: SELECT 'abc' ILIKE '%...LIKE with ESCAPE: SELECT 'A%c' ILIKE 'a$%c' ESCAPE '$' ; -- true There are also alternative characters that can be used as keywords in place of LIKE expressions. These enhance PostgreSQL compatibility. PostgreSQL-style LIKE -style ~~ LIKE !~~ NOT LIKE ~... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- PIVOT Statement – DuckDB 8385
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...syntax that automatically detects the columns to create while pivoting. PIVOT_WIDER may also be used in place of the PIVOT keyword. For details on how the PIVOT statement is implemented, see the Pivot Internals site . The UNPIVOT statement is the invers...de other SQL logic, as well as for multiple PIVOT s to be used in one query. No SELECT is needed within the CTE, the PIVOT keyword can be thought of as taking its place. WITH pivot_alias AS ( PIVOT cities ON year USING sum ( population ) GROUP BY countr... - https://man.mtool.work/duckdb/1.3/sql/statements/pivot.html
- UNPIVOT Statement – DuckDB 8385
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Man...a COLUMNS expression to automatically detect the columns to unpivot. PIVOT_LONGER may also be used in place of the UNPIVOT keyword. For details on how the UNPIVOT statement is implemented, see the Pivot Internals site . The PIVOT statement is the invers...ther SQL logic, as well as for multiple UNPIVOT s to be used in one query. No SELECT is needed within the CTE, the UNPIVOT keyword can be thought of as taking its place. WITH unpivot_alias AS ( UNPIVOT monthly_sales ON COLUMNS ( * EXCLUDE ( empid , dept... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
DuckDB 1.3 Documentation / man.mtool.work