From: <fs5_at_gmx.net>
Date: Thu, 22 Dec 2011 13:15:59 +0000 (GMT)

I'd like to see JPA 2.1 to support queries like this:

SELECT x
FROM MyEntity x
WHERE
  (x.p1, x.p2)
    IN
      (
        SELECT y.p1, MAX(y.p2)
        FROM MyEntity y
        GROUP BY y.p1
      )