17,082
社区成员
发帖
与我相关
我的任务
分享
SELECT tid,
SUM (CASE
WHEN item_id = 'A1'
THEN qty
ELSE NULL
END) qty01,
SUM (CASE
WHEN item_id = 'A2'
THEN qty
ELSE NULL
END) qty02,
SUM (CASE
WHEN item_id = 'A3'
THEN qty
ELSE NULL
END) qty03,
SUM (CASE
WHEN item_id = 'A4'
THEN qty
ELSE NULL
END) qty04,
..............
SUM (CASE
WHEN item_id = 'A50'
THEN qty
ELSE NULL
END) qty50
FROM table1
GROUP BY tid
SELECT tid,
SUM (CASE
WHEN item_id = 'A1'
THEN qty
ELSE NULL
END) qty01,
SUM (CASE
WHEN item_id = 'A2'
THEN qty
ELSE NULL
END) qty02,
SUM (CASE
WHEN item_id = 'A3'
THEN qty
ELSE NULL
END) qty03,
SUM (CASE
WHEN item_id = 'A4'
THEN qty
ELSE NULL
END) qty04,
..............
SUM (CASE
WHEN item_id = 'A50'
THEN qty
ELSE NULL
END) qty50
FROM table1
GROUP BY tid
ORDER BY tid