Re: converting a N rows table to a 1 row table ?

[Chris Curvey <chris@xxxxxxxxxxxxxxx>]

On Thu, Jul 3, 2014 at 8:30 AM, Arup Rakshit <aruprakshit@xxxxxxxxxxxxxx> 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.