Re: Many aggregates in one query
From: David Cressey <david_at_dcressey.com>
Date: Wed, 22 Aug 2001 12:51:26 GMT
Message-ID: <iVNg7.286$Iw2.19099_at_petpeeve.ziplink.net>
Date: Wed, 22 Aug 2001 12:51:26 GMT
Message-ID: <iVNg7.286$Iw2.19099_at_petpeeve.ziplink.net>
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.comReceived on Wed Aug 22 2001 - 14:51:26 CEST