Advanced Query Concepts

After you have mastered query fundamentals, you can explore these advanced query concepts for query solutions:

• Using aggregate functions in the select list
  
  
• Grouping rows with GROUP BY
  
  
• Combining results with UNION
  
  
• Subquery fundamentals
  
  
• Conditional data processing using CASE
  
  
• Parallel queries
  
  
• Summarizing data

See Also

Query Fundamentals