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