when write
Select mod(sal,comm)
from emp
where comm is not null;
we will find that the result of the mod(sal,comm) when comm = 0 is the same value
and this itself a big mathematical issues
(the problem in sql not in sql developer software because i tried it on online oracle work space also)
i am leaving you with the picture
thanks

