Results of 1 - 10 of about 14 for identical (0.004 sec.)
- CASE Expression – DuckDB 13548
- 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
.../ Expressions Copy Markdown CASE Expression The CASE expression performs a switch based on a condition. The basic form is identical to the ternary condition used in many programming languages ( CASE WHEN cond THEN a ELSE b END is equivalent to cond ? a :...ondition equivalent switch single conditions clause Documentation Expressions Copy Markdown Expression performs based form identical ternary used many programming languages expressed 関連するページ ALTER TABLE Statement NULL Values TRY expression Executin... - https://man.mtool.work/duckdb/1.3/sql/expressions/case.html
- Samples – DuckDB 11553
- 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
...l the data will be included, even when you ask for 50 PERCENT . Table Samples The TABLESAMPLE and USING SAMPLE clauses are identical in terms of syntax and effect, with one important difference: tablesamples sample directly from the table for which they a...clause is essentially equivalent to creating a subquery with the USING SAMPLE clause, i.e., the following two queries are identical: Sample 20% of tbl before the join: SELECT * FROM tbl TABLESAMPLE reservoir ( 20 % ), tbl2 WHERE tbl.i = tbl2.i ; Sample 2... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- HAVING Clause – DuckDB 9557
- 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
...GROUP BY clause to provide filter criteria after the grouping has been completed. In terms of syntax the HAVING clause is identical to the WHERE clause, but while the WHERE clause occurs before the grouping, the HAVING clause occurs after the grouping. E... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/having.html
- Directly Reading Files – DuckDB 8892
- 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
...B\xC3\xA4r test/sql/table_function/files/two.txt Schema The schemas of the tables returned by read_text and read_blob are identical: DESCRIBE FROM read_text ( 'README.md' ); column_name column_type null key default extra filename VARCHAR YES NULL NULL NU... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- Transaction Management – DuckDB 8892
- 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
...transaction made to the database. To abort a transaction, run: ROLLBACK ; You can also use the abort command, which has an identical behavior: ABORT ; If you are not in an active transaction, the ROLLBACK and ABORT statements will fail. Example We illustr... - https://man.mtool.work/duckdb/1.3/sql/statements/transactions.html
- SQL to/from JSON – DuckDB 8227
- 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
...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 always be semantically equivalent and produce the same output. Examples Simple examp... - https://man.mtool.work/duckdb/1.3/data/json/sql_to_and_from_json.html
- sqllogictest Introduction – DuckDB 8227
- 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
...his by running both an unoptimized and optimized version of the query, and verifying that the results of these queries are identical. Query verification is very useful because it not only discovers bugs in optimizers, but also finds bugs in e.g., join imp... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Execution Format – DuckDB 8227
- 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
...uous array, this is the standard uncompressed vector format. For flat vectors the logical and physical representations are identical. Constant Vectors Constant vectors are physically stored as a single constant value. Constant vectors are useful when data... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- Constraints – DuckDB 8227
- 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
...or every primary key or unique constraint that is defined in the table. Primary key constraints and unique constraints are identical except for two points: A table can only have one primary key constraint defined, but many unique constraints A primary key... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- ORDER BY Clause – DuckDB 8227
- 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
...DuckDB sorts ASC and NULLS LAST , i.e., the values are sorted in ascending order and NULL values are placed last. This is identical to the default sort order of PostgreSQL. The default sort order can be changed with the following configuration options. U... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/orderby.html
DuckDB 1.3 Documentation / man.mtool.work