select w2_month as x,w2_week as y,x-y as z from table例子:这里我用了x y 2个别名分别表示2个字段(number类型) 现在我想用别名进行相减 这种好像不可以,请问有什么办法可以解决吗?
实际需求:W2实际入库周 是更加一个select 语句获取的 --case when(W2实际入库周 - W2计划入库周) > 0 then '10'
-- when(W2实际入库周- W2计划入库周) = 0 then '20'
-- when(W2实际入库周 -W2计划入库周) < 0 then '30'
--end as 'W2是否按期入库类型',
实际需求:W2实际入库周 是更加一个select 语句获取的 --case when(W2实际入库周 - W2计划入库周) > 0 then '10'
-- when(W2实际入库周- W2计划入库周) = 0 then '20'
-- when(W2实际入库周 -W2计划入库周) < 0 then '30'
--end as 'W2是否按期入库类型',
解决方案 »
- 这种语句有什么问题么?
- 请问Oracle有什么小巧点的第三方备份工具吗?
- 求sql语句,求id为偶数的数据。
- 执行alter table ... shrink space时出现的错误
- 子查询是否必要?
- 动态创建视图
- 向各位大侠请教一个sql查询问题?
- 如何用命令禁用数据表的外键?
- powerdesigner报Non SQL Error :Couldnot load class oracle.jdbc.driver.OracleDriver
- linux下安装oracle不出现下一步
- oracle导出方案时内存不足
- Oracle文档里这样的图表符号是什么意思,在那个官方Oracle文档里有介绍这样图表的?
这个会被当做单独列来处理不知道这样子和需求相符合吗?hr@ORCL> create table t1 (id1 number,id2 number);Table created.hr@ORCL> insert into t1 values(1,2);1 row created.hr@ORCL> commit;Commit complete.hr@ORCL> with a as (select id1 x,id2 y,id1-id2 as z from t1)
2 select x,y,z from a; X Y Z
---------- ---------- ----------
1 2 -1
select w2_configure_id.nextval,'' as 统计汇总ID,C.Ordtype as 单据统计类型, D.cartypesn 车型代码,C.Dlrorderid as 采购单主单ID,B.Subdlrorderid as 采购单子单ID,
C.planinweek as W2计划入库周,
(select (w2_year||lpad(w2_month,2,0)||lpad(w2_week,2,0) )
from w2_configure
where A.Indate between w2_configure.w2_week_startday and w2_configure.w2_week_endday
and rownum = 1) as W2实际入库周,A.Indate as W2实际入库时间,
--case when(W2实际入库周 - W2计划入库周) > 0 then '10'
-- when(W2实际入库周- W2计划入库周) = 0 then '20'
-- when(W2实际入库周 -W2计划入库周) < 0 then '30'
--end as 'W2是否按期入库类型',
10,
10000,
sysdate as 操作时间,
A.Houseinid as 入库单ID
from t_vopr_housein_m A, t_vopr_dlrorder_d B, t_vopr_dlrorder_m C, t_vcar_car_m D
where A.Src_Billid = B.Subdlrorderid and B.Dlrorderid = C.Dlrorderid and B.CARID = D.CARID
W2实际入库周:
select (w2_year||lpad(w2_month,2,0)||lpad(w2_week,2,0) ) from w2_configure where A.Indate between w2_configure.w2_week_startday and w2_configure.w2_week_endday and rownum = 1) as
select (select a from table) as a,b,a-b as c from table1上面这种形式的 不行 不能用 a-b as c 别名不能这样用!!!
请问有什么办法 演变下处理!!!
(select w2_month x ,w2_week y from table)