Postgres Pro
Downloads
Home   >   mailing lists

Re: converting a N rows table to a 1 row table ? - Mailing list pgsql-general

From Chris Curvey
Subject Re: converting a N rows table to a 1 row table ?
Date
Msg-id CADfwSsCN_YSvQmpNWaMrHousq-4ieKeH03Ph5D20NNXkvR1Mqw@mail.gmail.com
Whole thread Raw
In response to converting a N rows table to a 1 row table ?  (Arup Rakshit <aruprakshit@rocketmail.com>)
List pgsql-general
Tree view



On Thu, Jul 3, 2014 at 8:30 AM, Arup Rakshit <aruprakshit@rocketmail.com> wrote:
Hi,

One query is producing the below table :-

answer |  count  |  avg
  a1       3         14
  a2       2         10

How to convert this to a single row table ?

count | avg_a1  | avg_a2
  5       14       10
 
Regards,
Arup Rakshit

select count(*)
, avg(case when answer='a1' then whatever_value else null end) as avg_a1
, avg(case when answer='a2' then whatever_value else null end) as avg_a2
from my_table





--
I asked the Internet how to train my cat, and the Internet told me to get a dog.

pgsql-general by date:

Previous
From: Pujol Mathieu
Date:
Subject: Re: converting a N rows table to a 1 row table ?
Next
From: T
Date:
Subject: What kinds of simple expressions need a snapshot?