Thread: converting a N rows table to a 1 row table ?
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
Arup Rakshit
Le 03/07/2014 14:30, Arup Rakshit a écrit :
Hi,Hi,One query is producing the below table :-answer | count | avga1 3 14a2 2 10How to convert this to a single row table ?count | avg_a1 | avg_a25 14 10Regards,
Arup Rakshit
Could you have multiple row with same answer ?
If I understand you one row and N + 1 column where N is the number of answer ?
Regards
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 | avga1 3 14a2 2 10How to convert this to a single row table ?count | avg_a1 | avg_a25 14 10Regards,
Arup Rakshit
select count(*)
, avg(case when answer='a1' then whatever_value else null end) as avg_a1
, 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.
Could you have multiple row with same answer ?
If I understand you one row and N + 1 column where N is the number of answer ?
Regards
You are right. Current it is fixed 2 answer. It means N = 2.