The Impala Query Language and Built-in Functions - Learning Cloudera Impala - page 74

SELECT name, age, class, city, state,
country FROM studentslist WHERE city =
'San Francisco';

Let's study the condition operators in the following table, which are used with
WHERE :

Operator Description

= Equal

<> Not equal to

> Greater than

< Less than

>= Greater than or equal to

<= Less than or equal to

BETWEEN Between an inclusive range

LIKE Search for a pattern