sql 连续排序的有关问题

sql 连续排序的问题
select Periods
  ,LotteryId
  ,TicketID
  ,Winning
  ,ROW_NUMBER() over (partition by ticketid,winning order by periods) num
 from  mTicketHist
 where TicketID = 'k_B4_01'
 order by Periods

得出以下结果:
Periods              LotteryId                                          TicketID                                       Winning    num     
-------------- --------------------------------------------- ------------------------------------------- ------------ -----------
1                    GDKL                                               k_B4_01                                            Y                  1
2                    GDKL                                               k_B4_01                                            Y                  2
3                    GDKL                                               k_B4_01                                            N                 1
4                    GDKL                                               k_B4_01                                            Y                  3
5                    GDKL                                               k_B4_01                                            Y                  4
6                    GDKL                                               k_B4_01                                            N                  2
7                    GDKL                                               k_B4_01                                            N                  3