是否可以按某个子查询来编写hql查询?有这样的查询:
select a from A.a join a.b where a.b.id = :id我需要的是:
select a from A.a join a.b where a.b.id = :id order by (select count(c) from C c where c.a = a.id) desc发布于 2012-07-26 20:31:54
我的别名系统似乎不起作用。或者它可能是hibernate的一个bug,但是这个东西可以工作(尽管效率非常低),我必须硬编码别名
SELECT a, (SELECT COUNT(c) FROM C c WHERE c.a = a.id) AS col_1_0_
FROM A.a
JOIN a.b
WHERE a.b.id = :id
ORDER BY col_1_0_我使用的是Hibernate 3和MySQL
https://stackoverflow.com/questions/11668895
复制相似问题