【多选题】
A SELECT * FROM employees WHERE salary + NVL2 (commission, commission, 0) >= 20000;
B SELECT * FROM employees WHERE salary + NULLIF (commission, 0) >= 20000;
C SELECT * FROM employees WHERE NVL2 (salary + commission, salary + commission, salary) >=
20000;
D SELECT * FROM employees WHERE COALESCE (salary, commission) >= 20000;
E SELECT * FROM employees WHERE salary + NVL (commission, 0) >= 20000;
查看更多
