获取基于值的总持续时间(以分钟为单位)。 [英] Fetch Total duration of time in minutes based on a value.
本文介绍了获取基于值的总持续时间(以分钟为单位)。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个表格,其中存在以下值。
Client_Id Load_1 RTC
TS1733 1 8/21/2014 16:10
TS1733 1 8/21/2014 17:00
< span class =code-leadattribute> TS1733 1 8/21/2014 17:10
TS1733 1 8/21/2014 17:20
TS1733 1 8/21/2014 17:30
TS1733 0 8 / 21/2014 17:40
TS1733 0 8/21/2014 17:50
TS1733 1 8/21/2014 18:00
TS1733 1 8/21/2014 18:10
TS1733 1 8/21/2014 18:20
< span class =code-leadattribute> TS1733 1 2014年8月21日 18:40
我想在1和0时获取Client_ID的总持续时间。
结果
Client_ID Load_1 TimeDuration(分钟)
TS1733 1 130
TS1733 0 20
如何我可以得到上述结果吗?请帮助..
解决方案
尝试:
SELECT Client_Id,Load_1,DATEDIFF(分钟,MIN(RTC),MAX(RTC)) AS [TimeDuration(Minute)]
FROM MyTable
GROUP BY Client_id,Load_1
I have a table in which the following values exist.
Client_Id Load_1 RTC
TS1733 1 8/21/2014 16:10
TS1733 1 8/21/2014 17:00
TS1733 1 8/21/2014 17:10
TS1733 1 8/21/2014 17:20
TS1733 1 8/21/2014 17:30
TS1733 0 8/21/2014 17:40
TS1733 0 8/21/2014 17:50
TS1733 1 8/21/2014 18:00
TS1733 1 8/21/2014 18:10
TS1733 1 8/21/2014 18:20
TS1733 1 8/21/2014 18:40
I want to fetch total duration of time of Client_ID when it was 1 and 0.
Result
Client_ID Load_1 TimeDuration(Minute)
TS1733 1 130
TS1733 0 20
How can i get the above result. Please help..
解决方案
Try:
SELECT Client_Id, Load_1, DATEDIFF(minute, MIN(RTC), MAX(RTC)) AS [TimeDuration(Minute)] FROM MyTable GROUP BY Client_id, Load_1
这篇关于获取基于值的总持续时间(以分钟为单位)。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文