空值参与运算
SELECT employee_id,last_name,salary * 12 * (1 + IFNULL(commission_pct,0)) AS "年薪"
FROM employees;
mysql语言
发布时间 2023-06-01 09:45:35作者: 每月工资一万八
空值参与运算
SELECT employee_id,last_name,salary * 12 * (1 + IFNULL(commission_pct,0)) AS "年薪"
FROM employees;