Subject | Problem in Nested aggregate functions -FireBird1.5 |
---|---|
Author | suresh.dodda@wipro.com |
Post date | 2006-05-04T04:35:51Z |
I am using following query.
I am getting the error: Nested aggregate functions are not allowed
Can any one suggest how to use nested aggregate functions?
SELECT MAX (COUNT (usr_id)) FROM usr_det GROUP BY usr_id;
[Non-text portions of this message have been removed]
I am getting the error: Nested aggregate functions are not allowed
Can any one suggest how to use nested aggregate functions?
SELECT MAX (COUNT (usr_id)) FROM usr_det GROUP BY usr_id;
[Non-text portions of this message have been removed]