Hi Linda, hi Mike,
the PFD version of the spec restricts the HAVING clause to grouping
items or aggregate functions applying to grouping items. Would it make
sense to allow aggregate functions over arbitrary fields (especially
non-grouping fields) in the HAVING clause? Today the following EJBQL
query is invalid. It groups employees by their department, but retains
only those departments where the average salary is greater than a
certain limit:
SELECT e.department FROM Employee e
GROUP BY e.department HAVING AVG(e.salary) > :limit
Regards Michael