Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Hint
Vince wrote:
> Just add a similar sum column, but instead of using quantity, use 1.
> ie. sum(decode(level,1,1,0)) as level_1_count
Thanks! That is exactly what I've looking for.
Ciao Received on Tue Feb 13 2007 - 02:21:44 CST