S02032
Error Code
S02032
Error Message
Cannot nest aggregate function. RefId:S02032
Probable Causes
Nesting aggregate functions is not allowed in DolphinDB SQL.
For example, the sum
function cannot be nested with another
sum
function.
item = table(1..10 as id, 10+rand(100,10) as qty)
select sum(sum(qty)) from item group by id
Solutions
Most major databases, such as MySQL, PostgreSQL, SQLite, and ClickHouse, do not support nested aggregate functions. Please reconsider your query semantics.