我有一张这样的桌子:
bookName updateId
----------------------------
LordOfTheRings 12
WheelOfTime 3
Cradle 9
WheelOfTime 14
Cradle 10
Cradle 11
如何构建一个CriteriaQuery来获得给定图书的最大updateId? 我需要这样的东西:
bookCriteriaQuery.select(bookRoot);
bookCriteriaQuery.and(
bookCriteriaBuilder.equal(bookRoot.get("bookName"), "Cradle"),
bookCriteriaBuilder.max(bookRoot.get("updateId")) // <--- except this doesn't work
);
Book newest = entityManager.createQuery(bookCriteriaQuery).getSingleResult();