so_damn_insane (![[info]](http://klab.lv/img/userinfo.gif){kind=small} so_damn_insane) rakstīja,@ 2011-10-04 16:55:00 |
 |
 |
 |
|
|
|
|
|
|
 |
|
 |
šodienas wtf
DECODE(
code
,'A'
,ABS(p_sum1 - p_sum2)
,'B'
,ABS(p_sum1 - p_sum2)
,'C'
,ABS(p_sum2 - p_sum1)
,'D'
,ABS(p_sum2 - p_sum1)
,0)
...
WHERE (p_sum1 > p_sum2 AND code in ('A','B'))
OR (p_sum1 < p_sum2 AND code in ('C','D'))
DECODE(
code
,'A'
,ABS(p_sum1 - p_sum2)
,'B'
,ABS(p_sum1 - p_sum2)
,'C'
,ABS(p_sum2 - p_sum1)
,'D'
,ABS(p_sum2 - p_sum1)
,0)
...
WHERE (p_sum1 > p_sum2 AND code in ('A','B'))
OR (p_sum1 < p_sum2 AND code in ('C','D'))
Nopūsties:
