Home > mailing lists

Re: converting a N rows table to a 1 row table ? - Mailing list pgsql-general

From	Pujol Mathieu
Subject	Re: converting a N rows table to a 1 row table ?
Date	July 3, 2014 15:46:50
Msg-id	53B550B1.8080700@realfusio.com Whole thread Raw
In response to	converting a N rows table to a 1 row table ? (Arup Rakshit <aruprakshit@rocketmail.com>)
Responses	Re: converting a N rows table to a 1 row table ? (Arup Rakshit <aruprakshit@rocketmail.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Arup Rakshit
Date: 03 July 2014, 15:30:24
Subject: converting a N rows table to a 1 row table ?

From: Chris Curvey
Date: 03 July 2014, 15:54:00
Subject: Re: converting a N rows table to a 1 row table ?

Re: converting a N rows table to a 1 row table ? - Mailing list pgsql-general

Previous

Next