Back to Questdb

CASE keyword

documentation/query/sql/case.md

latest1.0 KB
Original Source

Syntax

Description

CASE goes through a set of conditions and returns a value corresponding to the first condition met. Each new condition follows the WHEN condition THEN value syntax. The user can define a return value when no condition is met using ELSE. If ELSE is not defined and no conditions are met, then case returns null.

Examples

Assume the following data

nameage
Tom4
Jerry19
Anna25
Jack8
questdb-sql
SELECT
name,
CASE
    WHEN age > 18 THEN 'major'
    ELSE 'minor'
END
FROM my_table

Result

namecase
Tomminor
Jerrymajor
Annamajor
Jackminor
questdb-sql
SELECT
name,
CASE
    WHEN age > 18 THEN 'major'
END
FROM my_table

Result

namecase
Tomnull
Jerrymajor
Annamajor
Jacknull