ssh中的order by问题(关于包含有sum的sql运算如何排序)
SQL是
select * from(select nsr.nsrsbh as nsrsbh,nsr.nsrmc as nsrmc,sum(nvl(dlsj.dlfp_Cg_Fs,0)) as dlfpCgFs,sum(nvl(dlsj.dlfp_Cg_Je,0)) as dlfpCgJe,sum(nvl(dlsj.dlfp_Cg_Se,0)) as dlfpCgSe,sum(nvl(dlsj.dlfp_Dk_Fs,0)) as dlfpDkFs,sum(nvl(dlsj.dlfp_Dk_Je,0)) as dlfpDkJe,sum(nvl(dlsj.dlfp_Dk_Se,0)) as dlfpDkSe,nsr.nsr_Swjg_Dm as nsrSwjgDm from Tj_Nsrydsj dlsj,Dj_Nsrxx nsr where dlsj.nsrsbh = nsr.nsrsbh and dlsj.ssny >= '200801' and dlsj.ssny <= '200801' and nsr.nsr_Swjg_Dm like '1331%' group by nsr.nsrsbh,nsr.nsrmc,nsr.nsr_Swjg_Dm) order by dlfpCgFs
目的对sum的运算的这些字段可进行ORDER BY排序,本来想利用传统SQL而不用HQL,
Session session = rdao.getHibernateTemplate().getSessionFactory().openSession();
List list = session.createSQLQuery(SQL).addEntity("dlsj",TjNsrydsj.class).addEntity("nsr", DjDlNsrxx.class).class).list();
采用以上的方法老报错 提示列名无效,上面的SQL中对2张表的字段并未取全,但是直接在数据库中执行SQL是无任何错误的。请教大家用SSH的架构下如何对含有SUM运算的SQL使用ORDER BY.急求 望各位大哥帮忙。