Using offset and distribution functions
Last month, I started a series of articles about the profound window functions and their support in SQL Server 2012. I explained the concept of SQL windowing, I described the elements involved in window specifications (partitioning, ordering, and framing), and I discussed the difference between the two window frame unit options ROWS and RANGE. I showed examples using window aggregate functions. This month, I cover two other types of window functions: offset and distribution. If you missed ...
Buy This Project Plan Now!
This content is part of the Migrating to SQL Server 2012 Project Plan.
Purchase this Project Plan to receive:
- Step-by-step guidance for managing your project, start to finish
- Tested advice for preparing for and completing your project
- Insights to help you avoid common pitfalls and traps
Already registered? Log In here