DB2 Pivot(行到列) [英] DB2 Pivot (rows to columns)

问题描述

我在如下 DB2 表中有这样的数据.

I have data like this in a DB2 table like below.

Server Name Job ID  Job Status
SERVER_A    00000001    Success
SERVER_A    00000002    Failure
SERVER_A    00000003    Success
SERVER_B    00000004    Failure
SERVER_B    00000005    Failure
SERVER_B    00000006    Failure
SERVER_C    00000007    Success
SERVER_C    00000008    Success
SERVER_C    00000009    Success

我需要显示如下结果.

Server Name Success Failure
SERVER_A    2   1
SERVER_B    0   3
SERVER_C    3   0

推荐答案

解决方案一

select ServerName,
       sum(case when JobStatus='Success' then 1 else 0 end) Success,
       sum(case when JobStatus='Failure' then 1 else 0 end) Failure
from yourtable
group by ServerName

这篇关于DB2 Pivot(行到列)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！