Using SQLite Features—What You Can Do with SELECT Statements

There’s more to SELECT statements than just getting data. In addition to join clauses (discussed briefly in Chapter 4), you can order and group data as well as provide intermediate tables for doing what, in effect, are subselect operations. If you are used to procedural programming where you describe each step of a process (do this . . . do that, . . . if this is true do the other thing or else do that thing . . .), you may notice that SQL and relational databases encourage you to think in declarative programming ways (get me everything that is X, do something to all the Xs ...

Get Introducing SQLite for Mobile Developers 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.