SQL NULL Func

SQL NULL 函数

将 null 替换为某个值

ISNULL()

• SQL Server / MS Access

SELECT ISNULL(demo,0))
FROM demo

NVL()

• Oracle

SELECT NVL(demo,0))
FROM demo

IFNULL()

• Mysql

SELECT IFNULL(demo,0))
FROM demo

COALESCE()

• Mysql/Pgsql

SELECT COALESCE(demo,0))
FROM demo