没有为 ‘PAGE_TABLE_ALIAS‘ 的列 1 指定任何列名称。[5309] 开窗函数和 NEXT VALUE FOR 函数不支持常量作为 ORDER BY 子句表达式。

在sql server中遇到这个问题

解决办法：

//修改前
select sum(cast(fee as decimal(38,4))) as 'sumAccrualFee',MIN(date) as 'sDate',MAX(date) as 'eDate',paydate  
from bookfee
//修改后
select sum(cast(fee as decimal(38,4))) as sumAccrualFee,MIN(date) as sDate,MAX(date) as eDate,paydate as paydate
from bookfee