Results 1 to 2 of 2

Thread: Pivot table in Postgre

  1. #1
    Join Date
    May 2020
    Posts
    2

    Pivot table in Postgre

    I have one requirement to generate Pivot in XLS from Postgre SQL query. Here's my requirement

    My table has the below columns

    Region RSO Office Rep Name Premium
    REGION1 300
    RSO
    OFFICE
    REP1 100
    REP2 100
    REP3 100

    Can some one help me to write a query to generate Pivot ?

  2. #2
    Join Date
    May 2020
    Posts
    2
    [QUOTE=kayrajaram;135036]I have one requirement to generate Pivot in XLS from Postgre SQL query. Here's my requirement

    My table has the below columns(pls refer the attached file)
    Can some one help me to write a query to generate Pivot ?
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •