如何从与用于计算

Question

查询选择数据

我的表有1000行和两个主要栏目（invoice_no，exe_amount），我想写以下查询：

select invoice_ no, 
     exe_amount, 
     exe_amount*0.02 as edu_duty, 
     exe_amount*0.01 as ed_duty, 
     (exe_amount + edu_duty + ed_duty) as sub_total, 
     subtotal*0.0605 as st_amount, 
     sub_total*.0103 as ot_amount, 
     exe_amount + subtotal + st_amount + ot_amount as gd_amount 
from table1; 

如果我和变量查询接近它给出多个值的错误。

我该如何解决这个问题？ Aany教程链接解决问题？

Answer 1

你不能使用别名，而计算

select invoice_ no, 
     exe_amount, 
     exe_amount*0.02 as edu_duty, 
     exe_amount*0.01 as ed_duty, 
     (exe_amount + (exe_amount*0.02) + (exe_amount*0.01)) as sub_total, 
     ((exe_amount + (exe_amount*0.02) + (exe_amount*0.01)))*0.0605 as st_amount, 
     (exe_amount + (exe_amount*0.02) + (exe_amount*0.01)) *.0103 as ot_amount, 
     (exe_amount + 
     (exe_amount + (exe_amount*0.02) + (exe_amount*0.01)) + 
     ((exe_amount + (exe_amount*0.02) + (exe_amount*0.01)))*0.0605 + (exe_amount + (exe_amount*0.02) + (exe_amount*0.01)) *.0103 
    ) as gd_amount 
from table1; 

阿尔特原产于上述一个是

SELECT invoice_ no, 
     exe_amount, 
     edu_duty , 
     ed_duty, 
     sub_total, 
     subtotal*0.0605 as st_amount, 
     sub_total*.0103 as ot_amount, 
     exe_amount + subtotal + (subtotal*0.0605) + (sub_total*.0103) as gd_amount 
FROM (
     select invoice_ no, 
       exe_amount, 
       exe_amount*0.02 as edu_duty, 
       exe_amount*0.01 as ed_duty, 
       (exe_amount + (exe_amount*0.02) + (exe_amount*0.01)) as sub_total 
     from tableName 
)t