Re: SQL question
From: Henrik Staun Poulsen <hsp_at_infolog.dk>
Date: 1998/09/14
Message-ID: <35FD21F5.874BD3D8_at_infolog.dk>#1/1
Date: 1998/09/14
Message-ID: <35FD21F5.874BD3D8_at_infolog.dk>#1/1
Kumar,
<<select sum(sum(amount*decode(type,'S',1,'R',-1,1))) from order group
by
amount,type;>>
Thank you very much for your suggestion.
I'm not sure why I would want to use the 'group by' sub-clause, when I
just want the total sum?
I like the suggestion, thought. It looks fast.
Best regards
Henrik
Received on Mon Sep 14 1998 - 00:00:00 CEST