compute sum on VACHAR column

From: TR <tristan_robinson_at_cooltoad.com>
Date: 19 Apr 2006 09:24:00 -0700
Message-ID: <1145463840.059036.258730@t31g2000cwb.googlegroups.com>

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. Received on Wed Apr 19 2006 - 11:24:00 CDT