O'Reilly logo

Introducing SQLite for Mobile Developers by Jesse Feiler

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

CHAPTER 5

image

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 ...

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