[GENERAL] 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

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

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

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

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

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

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 You are right. Current it is fixed 2 answer. It means N = 2.