Abstract
In the previous chapters, we looked at retrieving a subset of rows and columns from a single table, and we also looked at how Cartesian products and joins can be used to retrieve data from two or more tables. In many of the examples it was possible to construct quite different SQL queries to produce the same result. Depending on the context or the problem you will probably find that one approach will feel more natural.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Clare Churcher
About this chapter
Cite this chapter
Churcher, C. (2016). Subqueries. In: Beginning SQL Queries. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1955-3_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1955-3_4
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)