Abstract
In this book, we’ve looked at different ways to tackle a variety of categories of queries. However, even if a query retrieves some valid-looking rows, all may not be well. In the previous chapter, we looked at the importance of checking the output to confirm that (at least some of) the expected rows are retrieved, as well as checking to make sure that (at least some) incorrect (or irrelevant) rows are not being returned.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Refer to my book Beginning Database Design (New York: Apress, 20xx) for more information.
- 2.
This is the difference between a relation that is defined as having unique tuples and a table that can have duplicate rows. See Appendix 2 for further information.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Clare Churcher
About this chapter
Cite this chapter
Churcher, C. (2016). Common Problems. In: Beginning SQL Queries. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1955-3_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1955-3_12
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)