Re: [GENERAL] Calcuate percentage. - Mailing list pgsql-general

From Sze Yuen Wong
Subject Re: [GENERAL] Calcuate percentage.
Date
Msg-id 19990309151027.12960.rocketmail@send202.yahoomail.com
Whole thread Raw
Responses Table as parameter in function
Re: [GENERAL] Calcuate percentage.
List pgsql-general
Can I somehow get the total number of rows in
a function?

if so, then I can say:

select var1, count(*) / numRows() * 100 from table1 group by var1;

Sze Wong



---"K.T."  wrote:
>
> select var1, count(*) from table1 group by var1;
>
> will get you the count of how many of each number there is...
>
> I think the only way is to get the max and manually loop thru the
rows and
> calc the percentage.
>
> -----Original Message-----
> From: Sze Yuen Wong <swong_@yahoo.com>
> To: pgsql-general@hub.org <pgsql-general@hub.org>
> Date: Tuesday, March 09, 1999 9:48 AM
> Subject: [GENERAL] Calcuate percentage.
>
>
> >Hi,
> >
> > I need to calcuate the percentage from my table:
> >
> >var1
> >------
> >1
> >1
> >1
> >2
> >2
> >3
> >
> >Desire result:
> >
> >var1 |  percentage
> >----------------------------
> >1      |    50%
> >2      |    33%
> >3      |    17%
> >
> >===============================
> >
> >Any clue?
> >
> >Please help.
> >
> >Sze Wong
> >
> >
> >
> >
> >
> >
> >_________________________________________________________
> >DO YOU YAHOO!?
> >Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
>
>
>

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-general by date:

Previous
From: Sze Yuen Wong
Date:
Subject: Re: [GENERAL] Calcuate percentage.
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [INTERFACES] the last row in a table