Query and modify data

This section describes how to query and modify data, including how to use joins. It includes several chapters on queries, from simple to complex, and information about inserting, deleting, and updating data. This chapter also includes an in-depth look at how to create analytical queries that return multidimensional results.


Queries
Full text search
Summarizing, grouping, and sorting query results
Joins: Retrieving data from several tables
Common table expressions
OLAP support
Use of subqueries
Data manipulation statements