About Question enthuware.oce-jpad.v6.2.489 :

Moderator: admin

Post Reply
Posts: 358
Joined: Fri Nov 29, 2013 8:26 pm

About Question enthuware.oce-jpad.v6.2.489 :

Post by himaiMinh »

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests