About Question enthuware.oce-jpad.v6.2.489 :
Posted: Sat Aug 12, 2017 6:47 pm
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.
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.