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

I did self join and take 1st row. But is there better and efficient way to do it? Select TOP(1) a.AppOwner as 'Owner', b.AppDev as 'Dev', c.aAppTester as 'Tester FROM myTable m JOIN myTable a on a.type = m.type and a.identifier = 'AppOwer JOIN myTable b on b.type = m.type and b.identifier = 'AppDev' JOIN myTable c on c.type = m.type and c.identifier = 'AppTester'