Create a query that displays the employees’ last names and commission amounts

If an employee does not earn commission, show “No Commission.” Label the column

.COMM

and my solution is

('select last_name,nvl2(commission_pct,commission_pct,'No commission

comm

from employees

but have error

تم تعديل 30 مارس 201312 سنة بواسطة منمون علي

استخدم دة كدا

('select last_name,nvl2(commission_pct,'No commission

comm

from employees

تم تعديل 30 مارس 201312 سنة بواسطة ahmedez3

try to change the 1st value to be char

Select last_name, nvl2 (commission_pct , to_char(commission_pct) , 'No commission' ) comm

from employees

Regards

;select ename, DECODE (COMMISSION, NULL, 'No Commission', 'Commission') from emp
or

select ename,nvl2(comm,'comm','no comm') from emp ;

try to change the 1st value to be char

Select last_name, nvl2 (commission_pct , to_char(commission_pct) , 'No commission' ) comm
from employees


Regards

thanks this correct

try to change the 1st value to be char

Select last_name, nvl2 (commission_pct , to_char(commission_pct) , 'No commission' ) comm
from employees


Regards

thanks this correct

You welcome
Best Regards

صلي عليه الرسول صلي الله علية وسلم