-- 你写的SQL语句有问题吧.好象应该这样.SELECT * from userarchive200607
where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
and UserMainRecordFlag_STR = '主记录'
group by usernumber_str
having sum(userfee_mon) > 10
order by UserNumber_STR;
where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
and UserMainRecordFlag_STR = '主记录'
group by usernumber_str
having sum(userfee_mon) > 10
order by UserNumber_STR;
写成SELECT * from userarchive200607 where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
group by usernumber_str having sum(userfee_mon) > 10
and UserMainRecordFlag_STR = '主记录' order by UserNumber_STR在sql里面也可以执行哈
但是用java就不行了
由于其他原因不能写成
SELECT * from userarchive200607
where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
and UserMainRecordFlag_STR = '主记录'
group by usernumber_str
having sum(userfee_mon) > 10
order by UserNumber_STR;
是不是那错了啊 而且数据库要对应