Advanced Query Concepts
From Accessing and Changing Relational Data
Accessing and Changing Relational Data
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