1.运算:所有包含NULL的加减乘除计算,结果都是NULL
select 1+null;
select 1-null;
select 2*null;
select 3/null;
select null/4;
select null/0;
2.判断是否为NULL: IS NULL
select vend_id,vend_state
from Vendors
where vend_state IS NULL;
原数据:
3.选择不为NULL的数据:IS NOT NULL
select vend_id,vend_state
from Vendors
where vend_state IS NOT NULL;