Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: No subselect in SELECT clause?
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