Select Day(EnrolDate) as MdateTime,Count(*) as Person,sum(ChargMoney) as ChargMoney
from Register Group by Day(EnrolDate);
报错如下:
line:5
SQLSTATE = 37000
[IBM][Client Access Express ODBC 驱动程序(32位)][DB2/400 SQL]sql0104 - Token ( was not
valid. Valid tokens: FOR WITH ORDER UNION OPTIMIZE.
数据类型:
EnrolDate --- TIMESTAMP
ChargMoney --- DECIMAL(9,2)
函数使用问题,
Day 是对单行操作的
count,sum是对多行的,所以出错,
day 单独处理吧