以此类推,数据库为oracle 用outer apply函数匹配出每个月的单价或者据这个月最早有值的前面月份的单价,一直提示缺失表达式; 但是代入数值单独执行outer apply里面的sql,是没问题的,这个要怎么解决 select tt.price from (SELECT FUnitActualCost as price,row_number()over(partition by t.FMaterialID,to_char(t.FBizDate,'YYYY') order by t.FBizDate desc) as an FROM T_IM_OtherIssueBillEntry t where t.FMaterialID ='TlYEd0tlSkGoZCTH8lAMl0QJ5/A=' and to_char(t.FBizDate,'YYYY') =2022 and t.FBizDate<= sysdate and nvl(FUnitActualCost,0)<>0 )tt where tt.an =1 |
最佳回答 |
||||
0
|
|