反轉欄位

反轉範例

SELECT io_month, [I22], [I23], [M02], [M03]

FROM

(SELECT io_month, pay_id, item_money FROM pay_employee WHERE employee_id = '103183'

AND io_month IN ('201609', '201610')

AND pay_id IN ('I23', 'M03', 'M02', 'I22')) AS pay

pivot

(sum(item_money)

FOR pay_id IN ([I22], [I23], [M02], [M03])

) AS id