我有一个相当简单的查询,可以在标准SQL中工作,但在HQL中不起作用:
SELECT id
FROM ( SELECT COUNT(*) as rows,
MESSAGES_ID as id
FROM motcles_message mm
WHERE motcle IN :keyWords
GROUP BY MESSAGES_ID) a
WHERE a.rows = :size
有什么方法可以避免在 FROM 语句中使用子查询,因为 HQL 不支持它? 我知道它可以在 SELECT 和 WHERE 子句中使用子查询,但我找不到解决方案。
SELECT MESSAGES_ID as id
FROM motcles_message mm
WHERE motcle IN :keyWords
GROUP BY MESSAGES_ID
HAVING COUNT(*) = :size