matlab 列转行,postgresql 行转列，列转行后加入到一个整体数据

这里行转列的基本思想就是使用max，因为其他列下面都是NULL,所以可以Max最后就只能得到有值的这行

普通的查询：

SELECT

icd ,

case when

(ROW_NUMBER() OVER(PARTITION BY INNER_CD ORDER BY SLIDE_SEQ )) = then SLIDE_QTY END as SLIDE_QTY1,

case when

(ROW_NUMBER() OVER(PARTITION BY INNER_CD ORDER BY SLIDE_SEQ )) = then SLIDE_S_UNIT_PRICE END as SLIDE_S_UNIT_PRICE1,

case when

(ROW_NUMBER() OVER(PARTITION BY INNER_CD ORDER BY SLIDE_SEQ )) = then SLIDE_QTY END as SLIDE_QTY2,

case when

(ROW_NUMBER() OVER(PARTITION BY INNER_CD ORDER BY SLIDE_SEQ )) = then SLIDE_QTY END as SLIDE_QTY3

FROM

"temp"."user" mm

WHERE

mm.icd = 'ADDM01-20160612-1-100002-001'

得到的数据是：

使用max后：

SELECT

MAX( case when SLIDE_SEQ = THEN SLIDE_QTY END )as SLIDE_QTY1,

MAX( case when SLIDE_SEQ = THEN SLIDE_QTY END )as SLIDE_QTY2,

MAX( case when SLIDE_SEQ = THEN SLIDE_QTY END )as SLIDE_QTY3,

MAX( case when SLIDE_SEQ = THEN SLIDE_QTY END )as SLI