From: | "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
---|---|
To: | "Sindile Bidla" <sindile(dot)bidla(at)gmail(dot)com>, "pgsql-novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How to compute percentages |
Date: | 2012-05-23 11:40:06 |
Message-ID: | 36695DD8501F4BF59C7BD38140FAF78E@marktestcr.marktest.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
Sindile,
Could you please try this variation of your own query, please?
Best,
Oliver
SELECT cl1, count(cl2) as no_accounts,
count(cl2) * 100.0 / (SELECT count(cl2) FROM tbl1) as percent_no_accounts,
sum(cl2) as consumption,
sum(cl2) * 100.0 / (SELECT sum(cl2) FROM tbl1) as percent_no_consumption
FROM tbl1
WHERE cl2 != 0
GROUP BY cl1
ORDER BY cl1;
----- Original Message -----
From: Sindile Bidla
To: pgsql-novice
Sent: Wednesday, May 23, 2012 12:23 PM
Subject: [NOVICE] How to compute percentages
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 | Bartosz Dmytrak | 2012-05-23 11:50:59 | Re: Page Usage Information |
Previous Message | Humberto Carvalho | 2012-05-23 11:37:54 | Re: How to compute percentages |