sql 同一行中，不同结果在不同列显示

select table1.guid, table1.content name, table2.content sex, 
table3.content age

from
(
select guid, content
from table
where type=‘姓名‘
) table1
,(
select guid, content
from table
where type=‘性别‘
) table2
,(
select guid, content
from table
where type=‘年龄‘
) table3
where table1.guid = table2.guid
and table2.guid = table3.guid