java - HQL select 子句中的多个选择

Question

我想在单个查询中获得多次计数的结果。在 native 查询中，我可以这样做:

`select (select count(*) from Foo where status = 1), (select count(*) from Foo where status = 2) ...`

如果我在 HQL 中这样做:

select (select count(f) from Foo f where f.status = 1), (select count(f) from Foo f where f.status = 2)

我收到错误:

<AST>:0:0: unexpected end of subtree

如何在 HQL 中做到这一点？

Answer 1

您的第一个选择不完整，如果您完成它应该没问题。

select (select count(f) from Foo f where f.status = 1), (select count(f) from Foo f where f.status = 2) from Foo;