Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: compute sum on VACHAR column
TR wrote:
> Hi,
>
> I have a varchar type column say Gender. I have shown the no. of
> people in the gender column as count(gender) Total_members. Now I want
> to compute sum of this Total_members column.
>
> And then calculate percentages for each member using the derived total
> for Total_members column.
>
> Can any one please suggest how do I go by?
>
> I used select sum(total_members) as grand_total from table1;
>
> Its giving me errors. So your help will be much appreciated.
>
> Thank you.
>
> TR.
Post your DML. We are not mind readers and this looks a lot like homework.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Apr 19 2006 - 11:34:37 CDT