In This Chapter

•   SELECT Statement: Its Clauses and Functions

•   Subqueries

•   Temporary Tables

•   Join Operator

•   Correlated Subqueries

•   Table Expressions

In this chapter you will learn how to use the SELECT statement to perform retrievals. This chapter describes several clauses in the SELECT statement and gives numerous examples using the sample and AdventureWorks databases to demonstrate the practical use of each clause. After that, the chapter introduces aggregate functions and the set operators, as well as computed columns and temporary tables. The second part of the chapter tells you more about complex queries. It introduces the join operator, which is the most important operator for relational database ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with O’Reilly online learning.

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