Collection Contents Index Working with indexes Query overview pdf/chap4.pdf

User's Guide
   PART 1. Working with Databases     

CHAPTER 4. Queries: Selecting Data from a Table


About this chapter 

The SELECT statement retrieves data from the database. You can use it to retrieve a subset of the rows in one or more tables and to retrieve a subset of the columns in one or more tables.

This chapter focuses on the basics of single-table SELECT statements. Advanced uses of SELECT are described later in this manual.


  Query overview
  The SELECT clause: specifying columns
  The FROM clause: specifying tables
  The WHERE clause: specifying rows

Collection Contents Index Working with indexes Query overview pdf/chap4.pdf