create table T
(
COMPUT CHAR(80),
RESOURCE_ID NUMBER,
RESOURCE_CODE VARCHAR2(50),
AMOUNT NUMBER
);
insert into t (COMPUT, RESOURCE_ID, RESOURCE_CODE, AMOUNT)
values ('({NET_SALES_REVENUE}-{SALES_COST})/({NET_SALES_REVENUE}-GROUP_EQUIPMENT_REVENUE)', 1, 'NET_SALES_REVENUE', 13074148.9395);
insert into t (COMPUT, RESOURCE_ID, RESOURCE_CODE, AMOUNT)
values ('({NET_SALES_REVENUE}-{SALES_COST})/({NET_SALES_REVENUE}-GROUP_EQUIPMENT_REVENUE)', 5, 'SALES_COST', 361514.0669);
insert into t (COMPUT, RESOURCE_ID, RESOURCE_CODE, AMOUNT)
values ('({NET_SALES_REVENUE}-{SALES_COST})/({NET_SALES_REVENUE}-GROUP_EQUIPMENT_REVENUE)', 7, 'GROUP_EQUIPMENT_REVENUE', 0);
select * from t;
COMPUT RESOURCE_ID RESOURCE_CODE AMOUNT
-------------------------------------------------------------------------------- ----------- -------------------------------------------------- ----------
({NET_SALES_REVENUE}-{SALES_COST})/({NET_SALES_REVENUE}-GROUP_EQUIPMENT_REVENUE) 1 NET_SALES_REVENUE 13074148.9
({NET_SALES_REVENUE}-{SALES_COST})/({NET_SALES_REVENUE}-GROUP_EQUIPMENT_REVENUE) 5 SALES_COST 361514.066
({NET_SALES_REVENUE}-{SALES_COST})/({NET_SALES_REVENUE}-GROUP_EQUIPMENT_REVENUE) 7 GROUP_EQUIPMENT_REVENUE 0
如何通过一个sql得到计算公式
({NET_SALES_REVENUE}-{SALES_COST})/({NET_SALES_REVENUE}-GROUP_EQUIPMENT_REVENUE) =(13074148.9-361514.066
)/(13074148.9-0)=0.972348940740609