SELECT trunc(ENERGYDATE,'mm') as QU, sum(energy) as ENERGY
FROM DISTRIBUTIONBOXENERGYINFO where ENERGYDATE >= '"+y1+"' and ENERGYDATE <='"+y2+"'
GROUP BY trunc(ENERGYDATE,'mm') order by QU
sql语句: SELECT trunc(ENERGYDATE,'mm') as QU, sum(energy) as ENERGY FROM DISTRIBUTIONBOXENERGYINFO where ENERGYDATE >= '"+y1+"' and ENERGYDATE <='"+y2+"' GROUP BY trunc(ENERGYDATE,'mm') order by QU sql语句能正确返回 现要拿那2个新命名的字段 qu 、ENERGY 我用的是SSH2(HibernateT