From: | Marcin Grondecki <ojciec(at)mtl(dot)pl> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Calcuate percentage. |
Date: | 1999-03-10 03:02:03 |
Message-ID: | 3.0.6.32.19990309190203.0080bcf0@mtl.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
select count (*) into t1 from t;
select count(varl), varl into t2 from t group by varl;
select varl, (t2.count*100/t1.count) from t2, t1;
and, of coz, drop tables t1 'n' t2 ;)
(i don't know it's my laminess, but syntax "select ... into TEMP ddd ...
does'n work for me - maybe suggestions? a bug i don't know about?)
At 06:54 99-03-09 -0800, you 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
>
>
>
Marcin Grondecki
ojciec(at)mtl(dot)pl
+48(604)468725
***** I'm not a complete idiot, some parts are missing...
From | Date | Subject | |
---|---|---|---|
Next Message | Rodney McDuff | 1999-03-10 03:17:28 | Multi-column Indexes. What is best Conan? |
Previous Message | Marcin Grondecki | 1999-03-10 02:32:51 | Re: [GENERAL] Re: [INTERFACES] the last row in a table |