create table emp(sal number,comm number);
select sal,comm,sum(sal+comm) into total from emp where comm is not null;
select sal,comm,(sal+comm) as total from emp where comm is not null;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)