我写了这个 SQL 查询:
SELECT TOP (15) UserName, EventName, EventTime
FROM AttendanceEvents
WHERE UserName = 'Kareem'
结果是:
如何将值分隔到事件的新列中?
我想要的输出是:
UserName | Login | LogOut
Kareem 2015-04-13 01:43 2015-04-13 13:44
Kareem 2015-04-18 12:39 NULL
Kareem 2015-04-18 12:43 NULL
.
.
.
Kareem 2015-04-25 00:35 2015-04-25 05:21
通过取 min 使用条件聚合
select username,cast(eventtime as date) as d, min(case when eventname='IN' then eventtime end) as login,
min(case when eventname='OUT' then eventtime end) as logout
from tablename
group by username,cast(eventtime as date)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句