In this blog post, you’ll learn more about the SQL Server Error Code 5309 and the error message description that is shown
SQL Server Error Code
5309
SQL Server Error Description for the Code :5309
Windowed functions, aggregates and NEXT VALUE FOR functions do not support constants as ORDER BY clause expressions.