I have a scenario where i have to pivot a list of rows to columns dynamically. Attaching a sample input table and desired output.I'm using postgreSQL and have tried crosstab function but the results is not correct.
Pivoting in PostgreSQL
Sandeep
- 113
- 1
- 5