On Wed, 22 Jan 2020 at 11:00, srikkanth <srikkanth16081991@xxxxxxxxxxxxxx> wrote:
Can you please help me in writing the syntax for the below mentioned table.
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
