时间戳

首页 > 解决方案 > Sql从行总和到列选择

sql - Sql从行总和到列选择

问题描述

------------------------------------------------------------------
 Itemcode | DocType  |  Qty     |
------------------------------------------------------------------
100011    | FA       | 100      |
100011    | FA       |  50      |
100011    | AJN      |  10      |
100011    | FA       | 100      |
100011    | AJN      | 50       |
-----------------------------------------------------------------

需要结果

------------------------------------------------------------------
 Itemcode | FA       | AJN  |
------------------------------------------------------------------
100011    | 250      |   0      |
100011    | 0        |  60      |
-----------------------------------------------------------------

标签： sqlselectsum

解决方案

试试这个，这里是演示。

select
    Itemcode,
    sum(case when DocType = 'FA' then Qty end) as FA,
    sum(case when DocType = 'AJN' then Qty end) as AJN,
from yourTable
group by
    Itemcode

推荐阅读