Re: sql question

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Sun, 19 Sep 2004 09:20:02 GMT
Message-ID: <6bc3d.16$jO1.4@newsfe3-win.ntli.net>

"Mirlok" <tima_at_azercell.com> wrote in message news:2r501vF167harU1_at_uni-berlin.de...
> Hi,
> How can this be rewritten as a single SQL script?
>
> declare
> sumtot number;
> sum1 number;
> sum2 number;
> begin
> select sum(column) into sum1 from table where condition1;
> select sum(column) into sum2 from table where condition2;
> sumtot:=sum1-sum2;
> end;
>
> Thank you in advance
>
>
>
>

select (sum(column) from table where condition1) - (sum(column) from table where condition2) from dual; Received on Sun Sep 19 2004 - 04:20:02 CDT