How to test for inequalities

You can use inequality operators to specify search conditions in your SELECT statements.

You can use the following inequalities to specify search conditions:

<>  <  <=  >  >=

Examples

To select all employees that were hired before January 1, 2001, you can use this query:

SELECT HIREDATE, FIRSTNME, LASTNAME
  FROM EMP
  WHERE HIREDATE < '2001-01-01';

This SELECT statement retrieves the hire date and name for each employee that was hired before 2001.