Isnull in sqlite

Syntax
The following illustrates the syntax of the IFNULL function.

IFNULL(parameter_1,parameter_2);
Arguments
The IFNULL function has exactly two arguments.

The IFNULL function is equivalent to the COALESCE function with two arguments. Note that the COALESCE function can have more than two arguments.

Return type
The IFNULL function returns the type of the argument or NULL.

Source: sqlitetutorial.net

Similar codes

5 votes140 views4 answers
Sql check
SQL
3 votes115 views2 answers
How to delete git repo locally
SQL
2 votes97 views1 answer
Oracle calculated column
SQL
2 votes104 views1 answer
Anonymous block plsql
SQL
0 vote106 views1 answer
Mysql two joins
SQL
0 vote98 views1 answer
Sql insert tuple
SQL
2 votes107 views3 answers
How to get second highest salary in each department in sql
SQL
5 votes109 views3 answers
Mysql remove unique constraint
SQL
1 vote99 views1 answer
How to select random rows from table
SQL
0 vote174 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL