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

From K.T.
Subject Re: [GENERAL] Calcuate percentage.
Date
Msg-id 000f01be6a3e$af498460$38dba5ce@p2-400-death
Whole thread Raw
List pgsql-general
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
>
>



pgsql-general by date:

Previous
From: Sze Yuen Wong
Date:
Subject: pgsql crash when selecting a view
Next
From: Sze Yuen Wong
Date:
Subject: Re: [GENERAL] Calcuate percentage.