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:
Query data by using subqueries and APPLY
Get Exam Ref 70-761 Querying Data with Transact-SQL, 1st Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
