Abstract
If a database has been designed correctly, the data will be located in several different tables. For example, our golf database has separate tables for information about members, teams, and tournaments, as well as tables that connect these values; for example, which members play on which teams, enter which tournaments, and so on. To make the best use of our data, we will need to inspect values from different tables to retrieve the information we require.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
In the formal terms of relational algebra, retrieving a subset of rows (tuples) from a table (relation) is known as the select operation and retrieving a subset of attributes (columns) is known as the project operation. See Appendix 2 for more information.
- 2.
- 3.
Formally, in terms of relational algebra, the result of every operation will generate another relation or set of unique rows. See Appendix 2 for more information.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Clare Churcher
About this chapter
Cite this chapter
Churcher, C. (2016). Simple Queries on One Table. In: Beginning SQL Queries. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1955-3_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1955-3_2
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1954-6
Online ISBN: 978-1-4842-1955-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)