Istudent Rana

Istudent Rana

  • 1.7k
  • 283
  • 29.6k

How do i project 3 different columns from 3 rows ?

May 27 2020 12:40 AM
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
 

Brought to you by:

Answers (1)