SQL NULL Func

Dreamhunter 2019/10/21 database

# 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