Chapter 16

Simple SQL Retrieval


This chapter begins a sequence of chapters that focus on SQL retrieval statements. This chapter covers specifying columns for display, and choosing rows from one table at a time. It introduces the construction of SQL predicates using relationship operators, logical operators, and SQL’s special operators.


SQL predicates
SQL operators
As we’ve said several times earlier, retrieval is what databases are all about: We put the data in so we can get them out in some meaningful way. There are many ways to formulate a request for data retrieval, but when it comes to relational databases, SQL is the international standard. It may not seem very “modern” because it’s a text-based language, ...

Get Relational Database Design and Implementation, 4th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.