Postgres Pro
Downloads
Home   >   mailing lists

Calcuate percentage. - Mailing list pgsql-general

From Sze Yuen Wong
Subject Calcuate percentage.
Date
Msg-id 19990309145446.14337.rocketmail@send204.yahoomail.com
Whole thread Raw
Responses Re: [GENERAL] Calcuate percentage.
List pgsql-general
Tree view 
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: "K.T."
Date:
Subject: Re: [GENERAL] the last row in a table
Next
From: Sze Yuen Wong
Date:
Subject: pgsql crash when selecting a view