SQL Comparison Operators

= Equal
<> Not Equal
> Greater than
>= Greater than or equal
< Less than
<= Greater than or equal
Examples:
SELECT EMPNO, LASTNAME, SALARY
FROM EMP
WHERE SALARY >= 20000

SELECT LASTNAME, FIRSTNAME, JOB
                                    FROM EMP
                                    WHERE JOB <> 'DESIGNER'

read more