1.查询一列的和
detachedCriteria.setProjection(Projections.sum("payAmount"));
2.查询两列积的和
detachedCriteria.setProjection(Projections.sqlProjection("sum(amount*price) as result", new String[] { "result" }, new Type[] { new DoubleType() }));
1.查询一列的和
detachedCriteria.setProjection(Projections.sum("payAmount"));
2.查询两列积的和
detachedCriteria.setProjection(Projections.sqlProjection("sum(amount*price) as result", new String[] { "result" }, new Type[] { new DoubleType() }));