Because each aggregate in a query requires its own worktable, an aggregate query cannot exceed the maximum number (46) of worktables allowed in a query.
If you include an aggregate function in the select clause of a cursor, that cursor cannot be updated
You cannot use aggregate functions on virtual tables such as sysprocesses and syslocks.
