The primary purpose of creating databases and tables in SQL Server is to store data and make that data available to users and application queries. Like any other Relational Database Management System (RDBMS), retrieval of data from a SQL Server database is a relatively straightforward task. In this chapter, you will learn how to get data from the databases using the Transact-SQL (T-SQL) SELECT statement. After reading through the chapter, you will be able to understand the following:
Transact-SQL SELECT, FROM, and WHERE clauses
Use a Transact-SQL function in a query
Multiple table queries using UNION, EXCEPT, INTERSECT, and JOINs
Use subqueries and CTEs to perform advanced queries
Organizing, grouping, and pivoting data
Use of the Transact-SQL analytic window functions
Note
This chapter contains a large number of example T-SQL queries, all of which require the
AdventureWorks2012database, which is available for download from http://msftdbprodsamples...