34,590
社区成员
发帖
与我相关
我的任务
分享
select card,
[01]=isnull([01],''),
[02]=isnull([02],''),
[03]=isnull([03],''),
[04]=isnull([04],''),
[05]=isnull([05],'')
from (select *,rn=row_number() over(partition by card,rq order by sktime) from source) t
pivot(max(sktime) for rq in([01],[02],[03],[04],[05])) p
/*
card 01 02 03 04 05
----- ----- ----- ----- ----- -----
00005 08:10 08:00
00005 12:11 12:20
00005 13:00 13:40
00005 17:10 17:22
00005 18:09
00005 20:10
(6 行受影响)
*/