Search Result: cond - DuckDB 2.0 全文検索

CASE Expression 9414: 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 : b ). With a single condition ... this can be expressed with IF(cond, a, b) . CREATE OR REPLACE TABLE integers AS SELECT unnest([1, 2, 3]) AS i; SELECT i, CASE WHEN i > 2 THEN 1 ELSE 0 END AS ... test FROM integers; i test 1 0 2 0 3 1 This is equivalent to: SELECT i, IF(i > 2, 1, 0) AS test FROM integers; The WHEN cond THEN expr part of the CASE expression can be chained, whenever any of the conditions returns true for a single tuple, the ... rs; i test 1 10 2 20 3 0 The ELSE clause of the CASE expression is optional. If no ELSE clause is provided and none of the conditions match, the CASE expression will return NULL . CREATE OR REPLACE TABLE integers AS SELECT unnest([1, 2, 3]) AS i; SEL ...; https://man.mtool.work/duckdb/2.0/sql/expressions/case.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work