Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-9407 Set-up parameter to the aggregate cannot

contain non-group columns.

If the user-defined aggregate has been defined with a set-up argument, the second argument of this aggregate must be either a constant or one of the columns in the GROUP BY clause of your query.

For example, the following two statements are valid:

SELECT new_aggr(colA, 2) FROM some_table

SELECT new_aggr(colA, colB) GROUP BY colB FROM some_table