Re: How to compute percentages

От

Oliveiros d'Azevedo Cristina

Тема

Дата

23 мая 2012 г. в 08:40:27

Msg-id

36695DD8501F4BF59C7BD38140FAF78E@marktestcr.marktest.pt

обсуждение

Список

pgsql-novice

Дерево обсуждения

How to compute percentages Sindile Bidla <sindile.bidla@gmail.com> 23 мая 2012 г. в 08:24:15

Re: How to compute percentages Humberto Carvalho <carvalho.humberto@gmail.com> 23 мая 2012 г. в 08:38:33

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

В списке pgsql-novice по дате отправления

Предыдущее

От: Humberto Carvalho

Дата: 23 мая 2012 г. в 08:38:33

Сообщение: Re: How to compute percentages

Следующее

От: Bartosz Dmytrak

Дата: 23 мая 2012 г. в 08:51:58

Сообщение: Re: Page Usage Information