SQL · System and metadata

iif()

A compact conditional expression. SQLite.

sqlRunnable example sql course

Syntax

iif(condition, then, else)

Example

Open in the lab

SELECT iif(84 >= 80, 'pass', 'retry') AS result;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.