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