前言 2021-01-08 22:24
sql中的行转列, 使用decode和case when
原表
效果表
(示例1):
select max(decode("type",1,"value")) 姓名,
max(decode("type",2,"value")) 性别,
max(decode("type",3,"value")) 年龄
from "test" group by "t_id"
(示例2):
select max(case "type" when 1 then "value" end) 姓名,
max(case "type" when 2 then "value" end) 性别,
max(case "type" when 3 then "value" end) 年龄
from "test" group by "t_id"