Hi, for the first explanation, it says aggregate function can be used only in SELECT, GROUP BY and HAVING clauses of a query.
But in 4.14 BNF section of the spec, aggregate function can be used in SELECT clause. It may be used in HAVING clause such as having count(presenations) > 0.
But so far, I don't see any example showing GROUP BY count(presentations) or GROUP BY MIN (student.score).
I wonder if aggregate function can be used after GROUP BY.
About Question enthuware.oce-jpad.v6.2.489 :
Moderator: admin
-
- Posts: 358
- Joined: Fri Nov 29, 2013 8:26 pm
- Contact:
Who is online
Users browsing this forum: No registered users and 9 guests