Re: Can I do this using SQL?

From: dhruv <dhruvbird_at_gmail.com>
Date: 9 Feb 2006 05:10:12 -0800
Message-ID: <1139490612.945872.141170@g43g2000cwa.googlegroups.com>

Hi,
Thanks a lot! Ok, so let me get this straight... If I have a count(), min(), max, avg() on the projection list, then I can use it with group by and the aggregate will be applied on EACH GROUP? Also, is ORDER BY always applied last(on the final result set).

Also, if I have a HAVING clause, will it too be applied on each GROUP?

If so, then can I always emulate HAVING by using subqueries, by projecting the fields after the HAVING keyword, and putting the condition after the HAVING keyword in the WHERE of the outher select?

-Dhruv. Received on Thu Feb 09 2006 - 07:10:12 CST