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: No subselect in SELECT clause?

Re: No subselect in SELECT clause?

From: Tomasz Gołebiowski <tgolebiowski_at_digest.com.pl>
Date: Fri, 22 Oct 1999 12:32:59 +0200
Message-ID: <38103D5B.E180CF52@digest.com.pl>


As I guess you want to have a sum of values in the second column... Try this one:
select col1, sum(col2)
from table_name
group by col1

tg Received on Fri Oct 22 1999 - 05:32:59 CDT

Original text of this message

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