COMPARISON OPERATORS

A comparison operator indicates how data should relate to the search value, such as “greater than” or “less than.”

  SELECT * 
FROM books
WHERE retail > 55

The “greater than” (4) comparison operator can also be used with text and date fields.

SELECT title
FROM books
WHERE title > 'HO'

Navigation menu