一则 ORA-00923: FROM keyword not found where expected解决原因：Select , cast( 改成Select a., cast

最新推荐文章于 2023-11-07 14:45:48 发布

左眼看成爱

最新推荐文章于 2023-11-07 14:45:48 发布

阅读量1.2k

点赞数 2

分类专栏：数据库技术文章标签： ORA-00923: a.*

本文链接：https://blog.csdn.net/wh445306/article/details/103186866

版权

本文介绍了如何解决在SQL查询中遇到的ORA-00923错误，该错误通常是由于FROM关键字的位置不正确或别名使用不当引起。通过将'Select *, '修改为'Select a.*, '，并确保使用表别名，可以成功解决此问题。" 127826316,15537067,理解数据流分析在编译器优化中的应用,"['编译原理', '程序分析', '算法', '软件工程']

摘要由CSDN通过智能技术生成

原报错SQL语句：

Select *, 
cast(Case When iCount=0 then 0 else (iYSYWFED*1.0)/iCount end as NUMBER(18,2)) as PerYSYWFED,
cast(Case When iCountEx=0 then 0 else (iYSYWFEDEx*1.0)/iCountEx end as NUMBER(18,2)) as PerYSYWFEDEx  From (
Select e.SeqNo2, c.Area,d.TypeName,  
cast(Sum(case when SUBSTR(BGRQ,1, 4)=to_char(sysdate,'yyyy') then 1 else 0 end) as Int) as iCount, 
Sum(case when SUBSTR(BGRQ,1, 4)=to_char(sysdate,'yyyy') then YSYWF else 0 end) as iYSYWFED,  
Sum(case when SUBSTR(BGRQ,1, 4)=cast(to_number( TO_CHAR(sysdate,'yyyy'))-1 as VARCHAR2(4)) then 1 else 0 end) as iCountEx, 
Sum(case when SUBSTR(BGRQ,1, 4)=cast(to_number( TO_CHAR(sysdate,'yyyy'))-1 as VARCHAR2(4)) then YSYWF else 0 end) as iYSYWFEDEx From BB_CONTENT1 a 
inner join (BB_CompanyList b inner join K_Company c on b.LoginID=c.LoginID) on a.CompanyGUID=b.GUID  
inner join BB_Type d on a.TypeID=d.GUID  
l