本文介绍了SQL Server查询分组问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
大家好，
我在sql数据处理方面遇到问题，下面给出了我的实际表DayWiseCount数据..
hi all,
i have issue with sql data processing ,my actual table DayWiseCount data is given below..
DepotCode RouteCode RouteName TotalSale DayNames DayNumber
113 113007 JEDS 01 SNACKS 55.9944 Saturday 1
113 113007 JEDS 01 SNACKS 139.986 Saturday 1
113 113007 JEDS 01 SNACKS 120 Saturday 1
113 113007 JEDS 01 SNACKS 150 Saturday 1
113 113007 JEDS 01 SNACKS 150 Saturday 1
113 113007 JEDS 01 SNACKS 60 Saturday 1
113 113007 JEDS 01 SNACKS 60 Saturday 1
113 113007 JEDS 01 SNACKS 30 Saturday 1
113 113007 JEDS 01 SNACKS 200 Saturday 1
113 113007 JEDS 01 SNACKS 900 Saturday 1
113 113007 JEDS 01 SNACKS 600 Sunday 2
113 113007 JEDS 01 SNACKS 450 Sunday 2
113 113007 JEDS 01 SNACKS 990 Sunday 2
113 113007 JEDS 01 SNACKS 60 Sunday 2
113 113007 JEDS 01 SNACKS 60 Sunday 2
113 113007 JEDS 01 SNACKS 405 Sunday 2
113 113007 JEDS 01 SNACKS 498 Sunday 2
113 113007 JEDS 01 SNACKS 855 Sunday 2
113 113007 JEDS 01 SNACKS 225 Sunday 2
113 113007 JEDS 01 SNACKS 990 Sunday 2
113 113007 JEDS 01 SNACKS 810 Sunday 2
113 113007 JEDS 01 SNACKS 990 Sunday 2
113 113007 JEDS 01 SNACKS 990 Sunday 2
113 113007 JEDS 01 SNACKS 60 Sunday 2
113 113007 JEDS 01 SNACKS 45 Sunday 2
113 113007 JEDS 01 SNACKS 60 Sunday 2
113 113007 JEDS 01 SNACKS 210 Sunday 2
113 113007 JEDS 01 SNACKS 150 Sunday 2
113 113007 JEDS 01 SNACKS 60 Sunday 2
113 113007 JEDS 01 SNACKS 60 Sunday 2
113 113007 JEDS 01 SNACKS 900 Sunday 2
113 113007 JEDS 01 SNACKS 90 Sunday 2
113 113007 JEDS 01 SNACKS 630 Sunday 2
113 113007 JEDS 01 SNACKS 90 Sunday 2
113 113007 JEDS 01 SNACKS 100 Sunday 2
113 113007 JEDS 01 SNACKS 315 Sunday 2
113 113007 JEDS 01 SNACKS 45 Sunday 2
113 113007 JEDS 01 SNACKS 900 Sunday 2
113 113007 JEDS 01 SNACKS 45 Sunday 2
113 113007 JEDS 01 SNACKS 90 Sunday 2
113 113007 JEDS 01 SNACKS 135 Sunday 2
113 113007 JEDS 01 SNACKS 90 Sunday 2
113 113007 JEDS 01 SNACKS 90 Sunday 2
113 113007 JEDS 01 SNACKS 180 Sunday 2
113 113007 JEDS 01 SNACKS 90 Sunday 2
113 113007 JEDS 01 SNACKS 45 Sunday 2
113 113007 JEDS 01 SNACKS 90 Sunday 2
113 113008 JEDS 02 SNACKS 13.9986 Saturday1
113 113008 JEDS 02 SNACKS 60 Saturday1
113 113008 JEDS 02 SNACKS 60 Saturday1
113 113008 JEDS 02 SNACKS 60 Saturday1
113 113008 JEDS 02 SNACKS 60 Saturday1
113 113008 JEDS 02 SNACKS 60 Saturday1
113 113008 JEDS 02 SNACKS 135 Sunday 2
113 113008 JEDS 02 SNACKS 180 Sunday 2
113 113008 JEDS 02 SNACKS 45 Sunday 2
113 113008 JEDS 02 SNACKS 30 Sunday 2
113 113008 JEDS 02 SNACKS 1095 Sunday 2
113 113008 JEDS 02 SNACKS 2190 Sunday 2
113 113008 JEDS 02 SNACKS 1980 Sunday 2
113 113008 JEDS 02 SNACKS 300 Sunday 2
113 113008 JEDS 02 SNACKS 210 Sunday 2
113 113008 JEDS 02 SNACKS 360 Sunday 2
113 113008 JEDS 02 SNACKS 975 Sunday 2
113 113008 JEDS 02 SNACKS 420 Sunday 2
但我需要处理此表，结果将是这样
but i need to process this table and result will be like that
DepotCode RouteCode RouteName TotalSale DayNames DayNumber record
113 113007 JEDS 01 SNACKS 55.9944 Saturday 1 1
113 113007 JEDS 01 SNACKS 139.986 Saturday 1 2
113 113007 JEDS 01 SNACKS 120 Saturday 1 3
113 113007 JEDS 01 SNACKS 150 Saturday 1 4
113 113007 JEDS 01 SNACKS 150 Saturday 1 5
113 113007 JEDS 01 SNACKS 60 Saturday 1 6
113 113007 JEDS 01 SNACKS 60 Saturday 1 7
113 113007 JEDS 01 SNACKS 30 Saturday 1 8
113 113007 JEDS 01 SNACKS 200 Saturday 1 9
113 113007 JEDS 01 SNACKS 900 Saturday 1 10
113 113007 JEDS 01 SNACKS 600 Sunday 2 1
113 113007 JEDS 01 SNACKS 450 Sunday 2 2
113 113007 JEDS 01 SNACKS 990 Sunday 2 3
113 113007 JEDS 01 SNACKS 60 Sunday 2 4
113 113007 JEDS 01 SNACKS 60 Sunday 2 5
113 113007 JEDS 01 SNACKS 405 Sunday 2 6
113 113007 JEDS 01 SNACKS 498 Sunday 2 7
113 113007 JEDS 01 SNACKS 855 Sunday 2 8
113 113007 JEDS 01 SNACKS 225 Sunday 2 9
113 113007 JEDS 01 SNACKS 990 Sunday 2 10
113 113007 JEDS 01 SNACKS 810 Sunday 2 11
113 113007 JEDS 01 SNACKS 990 Sunday 2 12
113 113007 JEDS 01 SNACKS 990 Sunday 2 13
113 113007 JEDS 01 SNACKS 60 Sunday 2 14
113 113007 JEDS 01 SNACKS 45 Sunday 2 15
113 113007 JEDS 01 SNACKS 60 Sunday 2 16
113 113007 JEDS 01 SNACKS 210 Sunday 2 17
113 113007 JEDS 01 SNACKS 150 Sunday 2 18
113 113007 JEDS 01 SNACKS 60 Sunday 2 19
113 113007 JEDS 01 SNACKS 60 Sunday 2 20
113 113007 JEDS 01 SNACKS 900 Sunday 2 21
113 113007 JEDS 01 SNACKS 90 Sunday 2 22
113 113007 JEDS 01 SNACKS 630 Sunday 2 23
113 113007 JEDS 01 SNACKS 90 Sunday 2 24
113 113007 JEDS 01 SNACKS 100 Sunday 2 25
113 113007 JEDS 01 SNACKS 315 Sunday 2 26
113 113007 JEDS 01 SNACKS 45 Sunday 2 27
113 113007 JEDS 01 SNACKS 900 Sunday 2 28
113 113007 JEDS 01 SNACKS 45 Sunday 2 29
113 113007 JEDS 01 SNACKS 90 Sunday 2 30
113 113007 JEDS 01 SNACKS 135 Sunday 2 31
113 113007 JEDS 01 SNACKS 90 Sunday 2 32
113 113007 JEDS 01 SNACKS 90 Sunday 2 33
113 113007 JEDS 01 SNACKS 180 Sunday 2 34
113 113007 JEDS 01 SNACKS 90 Sunday 2 35
113 113007 JEDS 01 SNACKS 45 Sunday 2 36
113 113007 JEDS 01 SNACKS 90 Sunday 2 37
113 113008 JEDS 02 SNACKS 13.9986 Saturday 1 1
113 113008 JEDS 02 SNACKS 60 Saturday 1 2
113 113008 JEDS 02 SNACKS 60 Saturday 1 3
113 113008 JEDS 02 SNACKS 60 Saturday 1 4
113 113008 JEDS 02 SNACKS 60 Saturday 1 5
113 113008 JEDS 02 SNACKS 60 Saturday 1 6
113 113008 JEDS 02 SNACKS 135 Sunday 2 1
113 113008 JEDS 02 SNACKS 180 Sunday 2 2
113 113008 JEDS 02 SNACKS 45 Sunday 2 3
113 113008 JEDS 02 SNACKS 30 Sunday 2 4
113 113008 JEDS 02 SNACKS 1095 Sunday 2 5
113 113008 JEDS 02 SNACKS 2190 Sunday 2 6
113 113008 JEDS 02 SNACKS 1980 Sunday 2 7
113 113008 JEDS 02 SNACKS 300 Sunday 2 8
113 113008 JEDS 02 SNACKS 210 Sunday 2 9
113 113008 JEDS 02 SNACKS 360 Sunday 2 10
113 113008 JEDS 02 SNACKS 975 Sunday 2 11
113 113008 JEDS 02 SNACKS 420 Sunday 2 12
请帮助我，我该怎么办....我花了2-4个小时，但我仍处于起点
感谢
please help me how can i do that ....i spend 2-4 hours but i am still at start point
thanks
推荐答案
SELECT DepotCode, RouteCode, RouteName , TotalSale, DayNames, DayNumber ,ROW_NUMBER() OVER(PARTITION BY DepotCode, DayNumber ORDER BY DepotCode, DayNumber) AS 'record'
FROM DayWiseCount
如果它解决了您的问题，请接受它作为答案或投票. ;)
If it solved you problem please accept it as an answer or vote it up. ;)
这篇关于SQL Server查询分组问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！