How do i project 3 different columns from 3 rows without creating temp table.
In my table, I have 3 columns name type, identifier and value
| type | identifier | value |
| myApp | AppOwner | The Owner |
| myApp | AppDev | The Dev |
| myApp | AppTester | The Tester |
How do i write query so that i can get data back as
| Owner | Dev | Tester |
| The Owner | The Dev | The Tester |
Istudent RanaPosted May 27, 2020, 9:23 AM