表:职业(姓名、职业)
Name Profession
Zahid Engineer
Rakib Doctor
David Singer
Farid Player
Arif Doctor
Tarik Singer
预期输出:
Doctor Engineer Singer Player
Rakib Zahid David Farid
Arif NULL Tarik NULL
我试过:
Select Doctor, Engineer, Singer, Player
from
( Select [Name], Profession from Occupation ) T1
PIVOT
(Max([Name]) for Profession IN ( Doctor, Engineer, Singer, Player)) T2
但是,它只输出一行:
Doctor Engineer Singer Player
Rakib Zahid Tarik Farid