| select 客户所属地区,sum(兑付金额) as 金额 from formmain where 费用落实与兑付单号 like 'cx%' group by 客户所属地区 查询数据没有问题，但是加上 to_char(修改时间,'yyyy-mm')>='${rq1}' and to_char(修改时间,'yyyy-mm')<='${rq2}' 语句变成 select 客户所属地区,sum(兑付金额) as 金额 from formmain where 费用落实与兑付单号 like 'cx%' and to_char(修改时间,'yyyy-mm')>='${rq1}' and to_char(修改时间,'yyyy-mm')<='${rq2}' group by 客户所属地区 查询失败，不知什么原因，请求帮助 |
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
