- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
select
--
(case
when (sum(distinct sub.est_cost) - sum(distinct sub.act_cost)) > 0 then
(sum(distinct sub.est_cost) - sum(distinct sub.act_cost))
when (sum(distinct sub.est_cost) - sum(distinct sub.act_cost)) < 0 then
(sum(distinct sub.est_cost) - sum(distinct sub.act_cost))
else
0
end)
--
from blablabla
Комментарии (0) RSS