SQL语句如下:
SELECT T1.ITEM,SUM(T1.ACT_COST21) COST,SUM(T1.COMPLETE_QTY) QTY, 6*QTY AS COST21 FROM GLOVIA_PROD.WO T1,GLOVIA_PROD.WO_COMP T2 where T2.TRAN_DATE BETWEEN TO_DATE('2010-07-01','YYYY-MM-DD') AND TO_DATE('2010-07-31','YYYY-MM-DD') and T2.CCN=T1.CCN and T2.MAS_LOC=T1.MAS_LOC and T2.WO_NUM=T1.WO_NUM and T2.WO_LINE=T1.WO_LINE AND T1.CCN='CHCIDG'GROUP BY T1.ITEM"
为什么引用计算列QTY时报错?
SELECT T1.ITEM,SUM(T1.ACT_COST21) COST,SUM(T1.COMPLETE_QTY) QTY, 6*QTY AS COST21 FROM GLOVIA_PROD.WO T1,GLOVIA_PROD.WO_COMP T2 where T2.TRAN_DATE BETWEEN TO_DATE('2010-07-01','YYYY-MM-DD') AND TO_DATE('2010-07-31','YYYY-MM-DD') and T2.CCN=T1.CCN and T2.MAS_LOC=T1.MAS_LOC and T2.WO_NUM=T1.WO_NUM and T2.WO_LINE=T1.WO_LINE AND T1.CCN='CHCIDG'GROUP BY T1.ITEM"
为什么引用计算列QTY时报错?
解决方案 »
- 求助!RAC2 节点上执行/u01/app/crs/root.sh报错!
- 如何在一个表中查询不为空的列,select * from 表名 where 列名 is not null 这个怎么查不出来,谢谢各位大侠
- 求一个简单的关于日期期间的算法
- 看到个纠结的题目,SQl高手们进来进来尽情发挥了哇哇哇哇!!!
- 不是高手请别进,不要随便吹,一定要说实解决方案!关于linux c++ 对于数据库DELETE操作
- sql中含有多余的表是否有问题
- 帮我看一条sql语句,想不通为什么会有这样的作用
- 急贴,oracle9i在linux下的安装问题!!!!
- oracle的最新版本是多少?中文名叫什么?
- 数据库平台的迁移
- Oracle求救,使用的是PL/SQL
- 一条记录都没有,insert时咋还能违反唯一性约束??
SUM(T1.COMPLETE_QTY) QTY, 6*SUM(T1.COMPLETE_QTY) AS COST21 --改成这样试试
FROM GLOVIA_PROD.WO T1,
GLOVIA_PROD.WO_COMP T2
where T2.TRAN_DATE BETWEEN TO_DATE('2010-07-01','YYYY-MM-DD')
AND TO_DATE('2010-07-31','YYYY-MM-DD') and
T2.CCN=T1.CCN and
T2.MAS_LOC=T1.MAS_LOC and
T2.WO_NUM=T1.WO_NUM and
T2.WO_LINE=T1.WO_LINE AND T1.CCN='CHCIDG'
GROUP BY T1.ITEM"
需要子查询
在ORDER BY中可用