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 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.