SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
An online community of DBAs, developers and data intelligence builders, with videos, articles, resources and online events for members and non-members.
Find out more >>
(Dave Stokes) Windowing Functions can get quite complex very quickly when you start taking advantage of the frame clause. Ranges and rows can get confusing. So for review lets look at how the specification looks: