Re: subracting numbers

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 23 Jan 2001 21:10:35 GMT
Message-ID: <94ks00$i6e$1@nnrp1.deja.com>

Try:

create view t_v as
select lastname, firstname, title, department,

       nvl(sum(decode(pay_type, 'Gross', amount, 0)),0) -
        nvl(sum(decode(pay_type, 'Bonus', amount, 0)),0) gross_no_bonus

from yourtable
group by lastname, firstname, title, department;

In article <94khgr$7i4$1_at_nnrp1.deja.com>,   pankrateon_at_my-deja.com wrote:
> the stage:
> Oracle 8i 8.1.6
> a table that contains employee info of which there is one column
 labeled
> "pay type"
> The "pay type" can be "Gross" or "Bonus".
> An other field is "Amount"
>
> table looks like this:
>
> lastname | firstname | title| department | pay_type | amount
>
> I want to be able to group by the persons name (last and first) and
 then
> subract
> any "Bonus" amount from their "Gross" amount
>
> I would want to create a view that looks as follows:
>
> lastname | firstname | title| department | gross - amount
>
> how do I do that?
> is it possible have this displayed as a view?
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 23 2001 - 15:10:35 CST