Обсуждение: Re: [GENERAL] Calcuate percentage.

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
>
>