select to_date(a.DT, 'yyyymmdd') ,
sum(a.REAL_POWER_LASTDAY) from KJDW.T_FCT_WEB_PROD_INFO a
group by to_date(a.DT, 'yyyymmdd')
FOR FETCH ONLY
通过工具执行 出现以下错误
16:42:35 [SELECT - 0 row(s), 0.000 secs] 1) [Error Code: -119, SQL State: 42803] DB2 SQL Error:
SQLCODE=-119, SQLSTATE=42803, SQLERRMC=DT, DRIVER=4.15.82. 2) [Error Code: -727, SQL State: 56098]
DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-119;42803;DT, DRIVER=4.15.82
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
通过db2cmd 执行 如下错误
db2 => select to_date(a.DT, 'yyyymmdd') as aaa , sum (nvl(a.REAL_POWER_LASTD
AY,0)) from KJDW.T_FCT_WEB_PROD_INFO a group by to_date(a.DT, 'yyyymmdd')
FOR FETCH ONLY
SQL0119N 在 SELECT 子句、HAVING 子句 或 ORDER BY 子句中指定的以 "DT"
开始的表达式未在 GROUP BY 子句中指定,或者它在 SELECT 子句、HAVING 子句或 ORDER
BY 子句中,具有列函数,但未指定 GROUP BY 子句。 SQLSTATE=42803
收起