User's Guide

Part II. Tutorials

Chapter 7. Selecting Data from Database Tables

Using the shortform BETWEEN

SQL has two short forms for typing in search conditions. The first, BETWEEN, is used when you are looking for a range of values. For example,

     SELECT emp_lname, birth_date
     FROM employee
     WHERE birth_date BETWEEN '1965-1-1'
     AND '1965-3-31'

is equivalent to:

     SELECT emp_lname, birth_date
     FROM employee
     WHERE birth_date >= '1965-1-1'
     AND birth_date <= '1965-3-31'

Using the short form IN

The second short form, IN, may be used when looking for one of a number of values. The command

     SELECT emp_lname, emp_id
     FROM employee
     WHERE emp_lname IN ('yeung','bucceri','charlton')

means the same as:

     SELECT emp_lname, emp_id
     FROM employee
     WHERE emp_lname = 'yeung'
     OR emp_lname = 'bucceri'
     OR emp_lname = 'charlton'