Re: A SQL Problem
From: Remco Blaakmeer <remco_at_rd31-144.quicknet.nl>
Date: 8 Mar 1999 23:43:36 GMT
Message-ID: <7c1nb8$ek5$1_at_rd31-144.quicknet.nl>
/
Date: 8 Mar 1999 23:43:36 GMT
Message-ID: <7c1nb8$ek5$1_at_rd31-144.quicknet.nl>
In article <MPG.1149b2c9bde0d1e9989681_at_news.hinet.net>,
agi_at_mail.taicom.com.tw (Agi Chen) writes:
>
> STK_NO YEAR RESULT(+) RESULT(-)
> ------ ----- --------- ---------
> 0001 1999 100
> 0002 1999 50
> 0003 1999 250
Hmm. Try something like this:
SELECT stk_no
, year , DECODE(SIGN(in-out),1,in-out) "result(+)" , DECODE(SIGN(out-in),1,out-in) "result(-)"FROM tableA
/
Remco
-- rd31-144: 12:35am up 3 days, 23:27, 7 users, load average: 1.00, 1.00, 1.08Received on Tue Mar 09 1999 - 00:43:36 CET