Relational Database Design and Implementation, 4th Edition

Chapter 16

Simple SQL Retrieval

Abstract

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.

Keywords

SQL

SQL SELECT

SQL WHERE

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