SELECT rq
, sum (case when dl = 'MDT' then lw else 0 end) MDTLW
, Count(case when dl = 'MDT' then lw else 0 end) MDTRC
, sum (case when dl = '普通' then lw else 0 end) 普通
, sum (case when dl = '特需' then lw else 0 end) 特需
, sum (case when dl = '专家' then lw else 0 end) 专家
FROM [表] where yggh='123456' group by rq
, sum (case when dl = 'MDT' then lw else 0 end) MDTLW
, Count(case when dl = 'MDT' then lw else 0 end) MDTRC
, sum (case when dl = '普通' then lw else 0 end) 普通
, sum (case when dl = '特需' then lw else 0 end) 特需
, sum (case when dl = '专家' then lw else 0 end) 专家
FROM [表] where yggh='123456' group by rq
扫一扫
543
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
