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