On Wed, 22 Jan 2020 at 11:00, srikkanth <srikkanth16081...@rediffmail.com> wrote:
> Can you please help me in writing the syntax for the below mentioned table. > Suggest looking at the crosstab function. https://www.postgresql.org/docs/current/tablefunc.html crosstab(text source_sql, text category_sql) Produces a "pivot table" with the value columns specified by a second query Geoff