Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query Hint

Re: Query Hint

From: ciccio <ciccio_at_ciccio.it>
Date: Tue, 13 Feb 2007 09:21:44 +0100
Message-ID: <45d1751d$1_2@x-privat.org>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US