Chapter 2. Query data with advanced Transact-SQL components

This chapter covers a number of T-SQL components that allow you to manipulate and analyze data, some of which might be considered more advanced than the ones covered in Chapter 1, “Manage data with Transact-SQL.” You will learn how to nest queries and use the APPLY operator, work with table expressions, apply data analysis calculations with grouping, pivoting, and windowing, query historical data from temporal tables, and query and output XML and JSON data.

Skills in this chapter:

Image Query data by using subqueries and APPLY

Query data by using table expressions

Group and pivot data by ...

Get Exam Ref 70-761 Querying Data with Transact-SQL, First Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.