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:
What the DISTINCT keyword is and why it’s valuable
How to use the FOR XML clause to return data as an XML document
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.
