查找不同值计数的 Hibernate 标准

Question

我有以下sql查询，我需要获取相应的hibernate条件查询

SELECT COUNT(DISTINCT employee_id) FROM erp_hr_payment WHERE payment_id IN(
SELECT payment_id FROM erp_hr_payment_collection WHERE payment_id IN(
SELECT payment_id FROM erp_hr_payment_collection WHERE payment_id IN(
SELECT payment_id FROM erp_hr_payment
 WHERE for_month BETWEEN '2013-04-01' AND '2014-03-31' AND arrear_flag=0
) AND element_name='EPF' ) AND element_name='EPFV');

Answer 1

从大多数内部查询开始，创建相关的 DetachedCriteria 并使用 Subqueries.in() 附加到外部查询。
对于 count(distinct) 使用 Projections.countDistinct(propertyName)。享受吧。