Using Comparison Conditions

SELECT last_name, salary

FROM   employees

WHERE  salary <= 3000 ;

Last_name	Salary
Edin	2400
John	2300

Using the BETWEEN Condition

Use the BETWEEN condition to display rows based on a range of values:

SELECT last_name, salary

FROM   employees

WHERE  salary BETWEEN 2500 AND 3500 ;

Last_name	Salary
Edin	2400
John	2300

Comparison Conditions

Operator	Meaning
=	Equal to
>	Greater than
>=	Greater than or equal to
<	Less than
<=	Less than or equal to
<>	Not equal to
BETWEEN ...AND...	Between two values (inclusive)
IN(set)	Match any of a list of values
LIKE	Match a character pattern
IS NULL	Is a null value

Character Strings and Dates

•      Character strings and date values are enclosed by single quotation marks.

•      Character values are case-sensitive, and date values are format-sensitive.

•      The default date format is DD-MON-RR.

•      SELECT last_name, job_id, department_id FROM   employees WHERE  last_name = 'Jenny' ;