Re: Crosstab function

From: Gowtham Vel <c8gowthamvel(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Crosstab function
Date: 2017-04-05 17:04:06
Message-ID: CAH-J9gYZrGyfMGwACi61-r6rqiMcme3cf3zTseHDpK4UnM36ug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Adrian,

Could you please check and update on my below email

Thanks
Gowtham K

On Apr 4, 2017 11:58 PM, "Gowtham Vel" <c8gowthamvel(at)gmail(dot)com> wrote:

> Hi Adrian,
>
> I have attached the input table and output table in below .xlsx sheet
>
> 1) I have removed the duplicate rows and sort the INPUT_TABLE i.e.,
> SELECT * FROM "public".INPUT_TABLE ORDER by 2,3
> 2) Input_table column name should be the column heading for Output_table.
> 3) Input_table column value should be the rows for Output_table.
> 4) some values i have mention in null , because its for future
> record(its might come)
> 5) please refer the below attached sheet and provide your assistance,
>
> Regards,
> Gowtham K
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2017-04-06 00:01:47 Re: Crosstab function
Previous Message Gowtham Vel 2017-04-04 18:28:26 Re: Crosstab function