O'Reilly logo

Beginning SQL Queries: From Novice to Professional, Second Edition by Clare Churcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Clare Churcher 2016

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

11. How to Tackle a Query

Clare Churcher

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

In the previous chapters, we saw different ways to express a query. We looked at the process approach, which describes how tables and data could be manipulated to produce the required result. These queries are expressed using keywords describing operations such as INNER JOIN and INTERSECTION. We also looked at how to express queries in terms of the outcome approach, which describes the criteria that the resulting data must satisfy rather than the process for retrieving the result.

However, sometimes when I am presented with a complicated natural language description of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required