Re: Many aggregates in one query

Saurabh,

If you consider creating a view to be cheating, then perhaps you can use this technique, and not consider it to be cheating:

select ...

from
(select ... ) testview,

etc.

Sorry, but I've lost the original problem, so I can't work out the details. But the idea is to substitute
the query for a table in the from clause.

--
Regards,
    David Cressey
    www.dcressey.com