SELECT
*
FROM
(
SELECT
MNY_50030101 AS STAFF_SALARY_H5,
--职工工资
MNY_500301 AS ADDITIONAL_FEE_I5,
--附加费
MNY_500304 AS DEPRECIATION_J5,
--折旧费
MNY_500314 LABOR_FEE_K5,
--劳务费
MNY_640110 TRADE_CONSUMABLE_L5,
--贸易耗材
MNY_500326 ASSIST_SPARE_PARTS_M5,
--辅料及零件
MNY_500320 TRANSPORT_FEE_N5,
-- 运输费
MNY_500315 ENERGY_O5,
--能源动力
MNY_500305 REPAIR_FEE_P5,
--修理
MNY_500311 RENT_Q5,
--租赁
MNY_OTHER OTHER_FEE_R5,
--其他
MNY_6001 INCOME_Y5,
--收入
MNY_6401 OPERATE_COST_Z5,
--营业成本
MNY_50030101 + MNY_500301 + MNY_500304 FIXED_COST_H5_I5_J5,
--固定成本
MNY_500314 + MNY_500326 + MNY_500320 + MNY_500315 + MNY_500305 + MNY_500311 + MNY_OTHER VAR_COST_U5,
--可变动成本
CASE NVL (MNY_6001, 0)
WHEN 0 THEN
0
ELSE
(
NVL (MNY_6001, 0) - NVL (MNY_6401, 0)
) / MNY_6001
END SALE_GROSS_PROFIT_RATE --销售毛利率
FROM
"SJCK"."LINE_ACCOUNT_014"
)
oracle中CASE WHEN语句的0值判断
最新推荐文章于 2023-04-11 11:35:07 发布