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