SQL Server SUM OVER ORDER BY Error: incorrect syntax near order

Pawan4u

THIS CODE NOT WORKING GIVING ERROR

Msg 102, Level 15, State 1, Line 2 Incorrect syntax near 'order'.

SELECT Id, StudentName, StudentGender, StudentAge,
SUM (StudentAge) OVER (ORDER BY Id) AS RunningAgeTotal
FROM Students

dharmend...

0 1

I will get back to you soon.

dharmend...

0 2

Remember not all database systems support ORDER BY in the OVER clause of a window aggregate function.

SQL Server didn't support it until the latest version SQL Server 2012.

So you need to use PARTITION BY.

SELECT Id, StudentName, StudentGender, StudentAge,
SUM (StudentAge) OVER (PARTITION BY ID) AS RunningAgeTotal
FROM Students

Refer below link for more details.