Selecting rows using conditions

You can specify any of the following conditions when you select rows:

=
Equal to
>
Greater than
> =
Greater than or equal to
<
Less than
< =
Less than or equal to
¬=
Not equal to
<>
Not equal to

The following query selects employees who earn a commission greater than or equal to $1,000.00.

SELECT ID, COMM
  FROM Q.STAFF
  WHERE COMM >= 1000

The following query selects employees who earn a commission of at least $170.00, but not more than $220.00.

                 
SELECT ID, COMM
  FROM Q.STAFF
  WHERE COMM BETWEEN 170 AND 220

For more information about the BETWEEN keyword, see the SQL reference manual for your database management system.

[ Previous Page | Next Page | Contents | Index ]