SQLite Flow Control Functions

As the name suggests, the flow control function is mainly used for flow control. This is similar to a statement in a programming language, if-elsea switchstatement. This page organizes flow control functions in SQLite.

  1. coalesce

    The SQLite coalesce() function returns the first non-null value in the parameter list.

  2. ifnull

    The SQLite ifnull() function is a if-else function that returns the second parameter if the first parameter is NULL, and otherwise returns the first parameter.

  3. iif

    The SQLite iif() function has 3 parameters, if the first parameter is true, it returns the second parameter, otherwise it returns the third parameter.

  4. nullif

    The SQLite nullif() function returns NULL if both parameters are the same, otherwise returns the first argument.