optional field行转列公式

erina.pan

MAX(CASE OPTFIELD WHEN '字段名1' THEN VALUE END) AS 列名1,
MAX(CASE OPTFIELD WHEN '字段名2' THEN VALUE END) AS 列名2,
MAX(CASE OPTFIELD WHEN '字段名3' THEN VALUE END) AS 列名3,
MAX(CASE OPTFIELD WHEN '字段名4' THEN VALUE END) AS 列名4,