22,209
社区成员
发帖
与我相关
我的任务
分享
期望结果是
che_no xingqi
黑K21D88 6 2
黑K21D88 5 1
示例数据 #cheliang_xihao
che_no work_no min_xche_jsrq max_xche_jsrq xche_jdrq xingqi timehour
黑EG1234 WX0820140800045 2014-08-06 09:19:39.000 2014-08-06 09:19:39.000 2014-08-06 08:55:04.297 4 8
黑K21D88 WX1320160800079 2016-08-22 14:11:45.000 2016-08-22 14:11:45.000 2016-08-22 13:17:34.683 2 13
黑K21D88 WX0420140900009 2014-09-02 14:07:47.000 2014-09-02 14:07:47.000 2014-09-02 14:02:43.090 3 14
黑K21D88 WX0320150600787 2015-06-28 14:35:06.000 2015-06-28 14:35:06.000 2015-06-28 14:34:18.317 1 14
黑K21D88 WX7420160800167 2016-08-19 17:41:16.000 2016-08-19 17:41:16.000 2016-08-19 17:38:10.383 6 17
SELECT id=row_number()over(order by MIN(work_no)), che_no,xingqi,COUNT(xingqi) xqcs from #cheliang_xihao where che_no='黑H21D88' group by che_no,xingqi
id che_no xingqi xqcs
1 黑K21D88 6 2
2 黑K21D88 5 1
3 黑K21D88 4 1
4 黑K21D88 7 1
5 黑EG1234 2 2