SELECT
last_name,
commission_pct
FROM
employees
WHERE
commission_pct <=> NULL;
案例:查询工资为 12000的员工信息
SELECT
last_name,
salary
FROM
employees
WHERE
salary <=> 12000;
is null
: 仅仅可以判断null值,可读性高,建议使用<=>
: 既可以判断null值,也可以判断普通数值,可读性差