Re: subracting numbers

Oracle8 SQL Language Reference. (Documentation). I'd recommend you to study SQL language itself, but don't know which good books are currently available.

In article <94l019$lvv$1_at_nnrp1.deja.com>,   pankrateon_at_my-deja.com wrote:
> Thanks!!! That did it. Do you have and recomendations on
> books which would help me out with other issues of this nature that
> I might have in the future.
>
> In article <94ks00$i6e$1_at_nnrp1.deja.com>,
> Alex Filonov <afilonov_at_pro-ns.net> wrote:
> > 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/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 16:27:15 CST