java - 条件查询EntityManager

Question

如何为以下 PL/Sql 代码编写条件查询？

SELECT a.eqis_type, a.eqis_des, a.eqis_rate
  FROM eqis a
 WHERE a.eqis_date IN (SELECT MAX (b.eqis_date)
                         FROM eqis b
                        WHERE b.eqis_type = a.eqis_type)
ORDER BY eqis_type;

标签： javajpacriteria-api