或者 Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b,Cast(send_sa as float)+Cast(isnull(send_sk,0) as float) as c from sendwrk_hx
SELECT a+b as c from (Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b from sendwrk_hx)
Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b, Cast(send_sa as float)+Cast(isnull(send_sk,0) as float) as c from sendwrk_hx
六楼的仁兄写的有点问题,应该是这么写 SELECT a+b as c from (Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b from sendwrk_hx) d 其中d是由括号内的SELECT语句生成derived_table 的别名 不错,不错,启迪了我的思维 送分,送分,Kelph() 高手,高手!
我的问题还要复杂,我的是: SELECT a+b as c,c+a as d from (Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b from sendwrk_hx) d
若这样的话是不是只能这样解决: select e.c+d.a+d.b as x from (SELECT d.a+d.b as c from (Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b from sendwrk_hx) s as d) as e 有没有更好的方法?
Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b,Cast(send_sa as float)+Cast(isnull(send_sk,0) as float) as c
from sendwrk_hx
Cast(send_sa as float)+Cast(isnull(send_sk,0) as float) as c
from sendwrk_hx
SELECT a+b as c from (Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b from sendwrk_hx) d
其中d是由括号内的SELECT语句生成derived_table 的别名
不错,不错,启迪了我的思维
送分,送分,Kelph()
高手,高手!
SELECT a+b as c,c+a as d from (Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b from sendwrk_hx) d
select e.c+d.a+d.b as x from
(SELECT d.a+d.b as c from
(Select Cast(send_sa as float) as a,Cast(isnull(send_sk,0) as float) as b from sendwrk_hx) s as d) as e
有没有更好的方法?