67,513
社区成员
发帖
与我相关
我的任务
分享
String sql = "select * from tb_brand as a inner join (select spid,sum(sl) as sl,sum(je) as je from tb_sell where xsdate between '2003-01-01' and 2009-01-01' group by spid ) as b on a.id=b.spid order by je desc ";
SQLQuery sqlQuery = session.createSQLQuery(sql);
List list = sqlQuery.list();