Hibernate 子查询问题
本帖最后由 wj481199 于 2013-12-24 13:37:09 编辑 现有需求一张表按某个字段分组查询, 而且要分页, 要得的分组后的记录总数来计算页数.
SQL可以这样写:
SELECT
SUM(a)
FROM
( SELECT
CASE
WHEN count(income_agent_id) IS NOT NULL THEN
1
ELSE
0
END AS a
FROM
deduct
WHERE
type <> 4
GROUP BY
income_agent_id,
MONTH (deduct_date)
) tmp;
select sum(t.a) from (select d.income.id as a from Deduct d group by d.income.id) tmp t;
先select d.income.id as a from Deduct d order by d.income.id,如果是给出某个组别的名称就直接where加条件好了,然后用hibernate自带的分页语句,setFirstResult和setMaxResults来设定,不知道能不能帮上你