From: | Sindile Bidla <sindile(dot)bidla(at)gmail(dot)com> |
---|---|
To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | How to compute percentages |
Date: | 2012-05-23 11:23:36 |
Message-ID: | CA+fb49Yfn3X6H+EbBDXZxf9fReRWRtwGkEtOMVpmM5UhhpYKMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have a query that is like this:
SELECT cl1, count(cl2) as no_accounts, sum(cl2) as consumption
FROM tbl1
WHERE cl2 != 0
GROUP BY cl1
ORDER BY cl1;
this gives me the following output
cl1 no_accounts consumption
a 2 50
b 1 100
c 5 30
On the same query i want to calculate percentages no_accounts and
consumption without having to create a table or view and then computing the
percentages
cl1 no_accounts percent_no_accounts consumption
percent_no_consumption
a 2 25
50 27
b 1 12
100 55
c 5 62
30 16
From | Date | Subject | |
---|---|---|---|
Next Message | Humberto Carvalho | 2012-05-23 11:37:54 | Re: How to compute percentages |
Previous Message | Willy-Bas Loos | 2012-05-22 07:34:16 | Re: SELECT FROM 'varying_table' |