SELECT first_name, salary, salary*12+(salary*NVL2 (commission_pct, salary,salary+commission_pct))“Total” FROM EMPLOYEES;
SELECT first_name, salary, salary*12+salary*commission_pct “Total” FROM EMPLOYEES;
SELECT first_name, salary (salary + NVL (commission_pct, 0)*salary)*12 “Total” FROM EMPLOYEES;
SELECT first_name, salary, salary*12 + NVL(salary,0)*commission_pct, “Total” FROM EMPLOYEES;
