首页 > itarticle > sql null func

sql null func

admin 10月 30, 2020 0

SQL NULL 函数

将 null 替换为某个值

1 2	SELECT ISNULL(demo,0)) FROM demo

1 2	SELECT NVL(demo,0)) FROM demo

1 2	SELECT IFNULL(demo,0)) FROM demo

1 2	SELECT COALESCE(demo,0)) FROM demo