September 2007
Intermediate to advanced
672 pages
13h 23m
English
Now that you have an idea of how to create a simple WHERE clause, let’s take a closer look at the five basic types of predicates you can define.
The most common type of condition is one that uses a comparison predicate to compare two value expressions to each other. As you can see in Figure 6-2, you can define six different types of comparisons using the following comparison predicate operators.
= Equals<> Not Equal To< Less Than> Greater Than<= Less Than or Equal To>= Greater Than or Equal To

You can easily ...