September 2007
Intermediate to advanced
600 pages
20h 21m
English
In the examples so far, you have used only the = (equal to) operator. You filtered rows based on their being equal to a specific value. Many other operators and conditions can be used with the WHERE clause; they’re listed in Table 6.2.
| Condition | Description |
|---|---|
| = | Equal to. Tests for equality. |
| <> | Not equal to. Tests for inequality. |
| < | Less than. Tests that the value on the left is less than the value on the right. |
| <= | Less than or equal to. Tests that the value on the left is less than or equal to the value on the right. |
| > | Greater than. Tests that the value on the left is greater than the value on the right. |
| >= | Greater than or equal to. Tests that the value on the left is greater than or equal to the value ... |
Read now
Unlock full access