At the weekend I had a question from an attendee at SQL Saturday in Cambridge. We were discussing SQL Azure and what it supports and didn’t and the significant improvements in version 12 (v12).
v12 made massive differences in what queries could be run on the PaaS database.
The question was whether SQL Azure supported certain windows functions statements such as ROWS UNBOUNDED PRECEDING.
After running the query below we can confirm that it ran successfully
OVER Clause (Transact-SQL) –
SQL Azure – ROWS UNBOUNDED PRECEDING