Help of writing a Query involivng horizontal and vertical totals.
From: ashok <arjdombivli_at_indiatimes.com>
Date: 8 Jan 2005 05:15:11 -0800
Message-ID: <1dc813f.0501080515.9fb6ebe_at_posting.google.com>
Dear all,
[Quoted] 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.
Date: 8 Jan 2005 05:15:11 -0800
Message-ID: <1dc813f.0501080515.9fb6ebe_at_posting.google.com>
Dear all,
[Quoted] 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 - 14:15:11 CET