79609

Selecting Particular Rows

As shown in the preceding section, it is easy to retrieve an entire table. Just omit the where clause

from the select statement. But typically you don't want to see the entire table, particularly when it

becomes large. Instead, you’re usually morę interested in answering a particular question, in which

case you specify some constraints on the information you want. Let’s

look at some selection queries in

terms of questions about your pets that they answer.