sqlserver游标不能order by排序的解决办法

set  @shopNameCurSor = CURSOR SCROLL FOR (select ShopName from [Record].[dbo].[B_Order] 
			where CreateTime >= @startTime and CreateTime <= @endTime
			group by ShopName order by ShopName)

会报错误--在关键字 'order' 附近有语法错误。

解决办法就是去掉FOR后面的小括号

set  @shopNameCurSor = CURSOR SCROLL FOR select ShopName from [Record].[dbo].[B_Order] 
			where CreateTime >= @startTime and CreateTime <= @endTime
			group by ShopName order by ShopName

这是我查找很多博客才发现的，很不容易，各位路过的大佬请点波关注，谢谢！