Re: [GENERAL] Calcuate percentage.

It's crude and not very efficient, but here is a solution:

CREATE TABLE temp ( var INT2 );
INSERT INTO temp VALUES (1);
etc.

CREATE FUNCTION temp_row_count() RETURNS FLOAT AS
'SELECT COUNT(*)::FLOAT AS result FROM temp'
LANGUAGE 'sql';

SELECT var, COUNT(*)::FLOAT / temp_row_count() AS pct
FROM temp GROUP BY var;

Hope this helps,

Clark

P.S.  In oracle, I'd use a sub-query:

SELECT var, COUNT(*) / total_count
  FROM temp,
       ( SELECT COUNT(*) AS total_count
           FROM temp
       )
GROUP BY var;




Sze Yuen Wong wrote:
>
> 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