Lesson 7. Taking the SELECT Statement to the Next Level

Lesson 6, “Getting to Know the SELECT Statement,” provided you with an introduction to the SQL SELECT statement. This lesson takes your knowledge of the SELECT statement to the next level. In this lesson, you learn:

Image What the DISTINCT keyword is and why it’s valuable

Image How to use the FOR XML clause to return data as an XML document

Image How to group and summarize data

How to apply criteria to summarized ...

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

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