© Clare Churcher 2016

Clare Churcher, Beginning SQL Queries, 10.1007/978-1-4842-1955-3_12

12. Common Problems

Clare Churcher

(1)Studio B Productions, Great Neck, New York, USA

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.

The problems that can befall queries are not just a matter of having the wrong syntax in SQL statements, although that can certainly happen. Problems with ...

Get Beginning SQL Queries: From Novice to Professional, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.