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_at_g43g2000cwa.googlegroups.com>
Date: 9 Feb 2006 05:10:12 -0800
Message-ID: <1139490612.945872.141170_at_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?
-Dhruv. Received on Thu Feb 09 2006 - 14:10:12 CET