sql query for horizontal and vertical sum.

Dear all,
I am using the emp like table from the oracle. MY requirement is
1.
to calculate the total sum of sal+comm;
select sal+comm from emp; would only print the results where comm in not NULL but I want to display the sal + comm for NULL comm values as well (i.e only sal will be displayed for sal + comm ) along with the other sal + comm values.

2.
alongwith the above requirement , i want the total of only all the sal fields (total sal)and total of all the comm fields(total comm).i.e vertical total of sal and comm fields.

I have just avergae knowledge of oracle and tried my best to write the above related queries but couldn't got the appropriate results.

I request you to kindly help me as I am totally stuck now..

regds,
arj Received on Sat Jan 08 2005 - 07:16:11 CST