Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 4. Modifying Data Using the Quer... > 4.1 Introducing the Query Builder
4.1 Introducing the Query Builder
The Query Builder is a tool for manipulating your data. The Query Builder takes a table (or tables), performs some type of data manipulation, and produces a new table. The set of data manipulation instructions defined in the Query Builder is called a query. There are several types of data manipulation you can perform in the Query Builder including:
Creating new columns based on values of existing columns
Summarizing data
Sorting data
Creating a subset of your data
Joining data tables
