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