标题: optional field行转列公式 [打印本页]

---

作者: erina.pan    时间: 2016-11-2 17:33     标题: optional field行转列公式

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,

---

欢迎光临 赛捷软件论坛 (http://114.215.210.180/bbs/)

Powered by Discuz! 7.2