Results of 1 - 10 of about 370 for expressions (0.004 sec.)
- SELECT Clause – DuckDB 11876
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...ause specifies the list of columns that will be returned by the query. While it appears first in the clause, logically the expressions here are executed only at the end. The SELECT clause can contain arbitrary expressions that transform the output, as well... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- Star Expression – DuckDB 10969
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...ctions Catch Internals Overview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Star Expression Syntax The * expression can be used in a SELECT statement to select all columns that are pro... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- PIVOT Statement – DuckDB 9348
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...N year IN ( 2000 , 2010 ) USING sum ( population ) GROUP BY country ; country 2000 2010 NL 1005 1065 US 8579 8783 Multiple Expressions per Clause Multiple columns can be specified in the ON and GROUP BY clauses, and multiple aggregate expressions can be inc... - https://man.mtool.work/duckdb/1.3/sql/statements/pivot.html
- Expression API – DuckDB 9251
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...n instance of an expression . Why Would I Use the Expression API? Using this API makes it possible to dynamically build up expressions, which are typically created by the parser from the query string. This allows you to skip that and have more fine-grained... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- Expressions – DuckDB 8343
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...ctions Catch Internals Overview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Expressions An expression is a combination of values, operators and functions. Expressions are highly compos... - https://man.mtool.work/duckdb/1.3/sql/expressions/overview.html
- Pattern Matching – DuckDB 8140
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...nal SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE expression returns true if the string matches the supplied pattern. (As expected, the NOT LIKE expression... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Friendly SQL – DuckDB 7735
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...ific columns from the * expression. SELECT * REPLACE : the REPLACE option allows replacing specific columns with different expressions in a * expression. UNION BY NAME : perform the UNION operation along the names of columns (instead of relying on positions... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- ORDER BY Clause – DuckDB 7127
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...an specify whether NULL values should be moved to the beginning or to the end. The ORDER BY clause may contain one or more expressions, separated by commas. An error will be thrown if no expressions are included, since the ORDER BY clause should be removed... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/orderby.html
- INSERT Statement – DuckDB 6925
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...l ( i ) VALUES ( 1 ); Syntax INSERT INTO inserts new rows into a table. One can insert one or more rows specified by value expressions, or zero or more rows resulting from a query. Insert Column Order It's possible to provide an optional insert column order... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- GROUPING SETS – DuckDB 6828
- 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
...lean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Funct...terval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Util...hich groups generated the super-aggregate rows in the result. GROUPING_ID() is an aggregate function that takes the column expressions that make up the grouping(s). It returns a BIGINT value. The return value is 0 for the rows that are not super-aggregate r... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/grouping_sets.html
DuckDB 1.3 Documentation / man.mtool.work