阅读背景:

SQL Server在不同的行之间找到datediff,sum

来源:互联网 

I am trying to build a query that analyzes data in our time tracking system. Every time a user swipes in or out, it makes a row recording the swipe time and On or Off site (entry or exit). In user 'Joe Bloggs' case there are 4 rows, which I want to pair and calculate a total time spent on site for Joe Bloggs.I am trying to build a query that analyzes data




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: