O'Reilly logo

Microsoft® SQL Server® 2012 T-SQL Fundamentals by Itzik Ben-Gan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Beyond the Fundamentals of Querying

This chapter starts with the profound window functions, which allow you to apply calculations against sets in a flexible and efficient manner. The chapter then proceeds with techniques for pivoting and unpivoting data. Pivoting means rotating data from a state of rows to a state of columns. Unpivoting means rotating data from a state of columns to a state of rows. The chapter then finishes with a discussion of grouping sets. Grouping sets are sets of attributes by which data can be grouped. This chapter covers techniques for requesting multiple grouping sets in the same query.

Note that all subjects covered in this chapter may be considered advanced for readers who are new to T-SQL; therefore, the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required