Re: Can I do this using SQL?

dhruv wrote:

> 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).

Yes.

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

Yes.

> 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?

I haven't run into any situation where this could not be done.

Btw, getting the first n rows can also be achieved by using a recursive common table expression to number the rows and then select the rows based on those numbers.

-- 
Knut Stolze