next up previous
Next: The from Clause Up: Basic Structure Previous: The select Clause

The where Clause

  1. The predicates can be more complicated, and can involve
  2. Example: Find account number of accounts with balances between $90,000 and $100,000.

     select account#

    from account

    where balance between 90000 and 100000

Osmar Zaiane
Fri May 22 19:39:12 PDT 1998