使用子句IN将sql转换为jpql

Question

我在SQL中有这个请求，我已经在JPQL 中转换了它

===SQL===
SELECT * FROM ELEVE WHERE ELEVE.AGE IN ('7','8','5','6', '12' ) 
===JPQL===
SELECT E FROM ELEVE E  WHERE E.AGE IN ('7','8','5','6', '12' ) 

但它不起作用，有人能解释我错过了吗

Answer 1

您缺少*或选择后的列名，它可以是E.*，也可以只是*，如果您想指定特定的列名，则应该像E.columnanme:

===SQL===
SELECT * FROM ELEVE WHERE ELEVE.AGE IN ('7','8','5','6', '12' ) 
===JPQL===
SELECT E.*  FROM ELEVE E  WHERE E.AGE IN ('7','8','5','6', '12' )