In this chapter, you learned the basic syntax of the SELECT
statement and how it can be used to query data from SQL Server database tables. You learned about the different categories of built-in T-SQL functions and used them in your queries. You learned the different techniques to combine data from multiple tables. You also learned how to organize the data and how to generate the summary data by grouping data or pivoting data. You also understood the purpose of the CTE. We then went through the purpose of window analytic functions and how to use them to quickly solve complex analytical tasks.
SQL Server 2014 Development Essentials
By :
SQL Server 2014 Development Essentials
By:
Overview of this book
Table of Contents (14 chapters)
SQL Server 2014 Development Essentials
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Microsoft SQL Server Database Design Principles
Understanding DDL and DCL Statements in SQL Server
Data Retrieval Using Transact-SQL Statements
Data Modification with SQL Server Transact-SQL Statements
Understanding Advanced Database Programming Objects and Error Handling
Performance Basics
Index
Customer Reviews