Re: [GENERAL] converting a N rows table to a 1 row table ?

[Pujol Mathieu]

Le 03/07/2014 14:30, Arup Rakshit a écrit :
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
Hi,
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