sql - 可以在 sql 的单行中显示数据

Question

我想在单行中显示数据，例如

TokenNo:AS894,NCBYPA:3,NCBYQA:1,NCBYIED:1 

TokenNo NCBYPA  NCBYQA  NCBYIED
AS894       0   0   1
AS894       3   0   0
AS894       0   1   0

标签： sqlsql-server

Answer 1

您似乎想要条件聚合。也就是说，case是聚合函数的参数：

select tokenNo,
       sum(case when category = 'NC by PA' then 1 else 0 end) as ncbypa,
       . . .   -- and so one for the other columns
from employeeNC
group by tokenNo