查找员工的奖金率(commission_pct)和最后得到的奖金(salary*commission_pct),但不是每个人都有奖金率。
oracle:nvl ( check_expression , replacement_value )
Select commission_pct, salary*nvl(commission_pct,0)from employees;
Sql server:isnull( check_expression , replacement_value )
Select commission_pct, salary*isnull(commission_pct,0)from employees;
Mysql: ifnull(check_expression , replacement_value)
Select commission_pct, salary*ifnull(commission_pct,0)from employees;