O'Reilly logo

Exam Ref 70-761 Querying Data with Transact-SQL, First Edition 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 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 ...

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