案例1:查询没有奖金的员工名和奖金率
- =或<>不能判断等于null
is null
,is not null
可以
SELECT
last_name,
commission_pct
FROM
employees
WHERE
commission_pct IS NOT NULL;
案例1:查询没有奖金的员工名和奖金率
is null
, is not null
可以SELECT
last_name,
commission_pct
FROM
employees
WHERE
commission_pct IS NOT NULL;