sql纵横转化 将列中内容作为字段

ID	name	age
1	xiaoming	11
2	xiaohua	12
3	xiaohong	23

 将上方数据name一列的值作为列名来展示内容：

select 
    (case name when 'xiaoming' then age else 0 end) as xiaoming,
    (case name when 'xiaohong' then age else 0 end) as xiaohong,
    (case name when 'xiaohua' then age else 0 end) as xiaohua
 from student
    
    

xiaoming	xiaohong	xiaohua
11	0	0
0	12	0
0	0	23