Home > Sample chapters > Programming > SQL Server

SQL Windowing

Summary

This chapter introduced the concept of windowing in SQL. It provided the background to window functions, explaining the motivation for their use. The chapter then provided a glimpse of solving querying tasks using window functions by addressing the task of identifying ranges of existing values in a sequence—a problem also known as identifying islands. The chapter then proceeded to explain the design of window functions, covering the elements involved in window specifications: partitioning, ordering, and framing. Finally, this chapter explained how standard SQL addresses the need to reuse a window specification or part of it. The next chapter provides a breakdown of window functions, getting into more detail.