SQL Statements for Flat-File Drivers : Select Statement : SQL Expressions : Relational Operators

Relational Operators
Relational operators separating any two expressions can be any one of those listed in the following table.
The following list shows some examples of relational operators:
salary <= 40000
dept = 'D101'
hire_date > {01/30/1989}
salary + commission >= 50000
last_name LIKE 'Jo%'
salary IS NULL
salary BETWEEN 10000 AND 20000
WHERE salary = ANY (SELECT salary FROM emp WHERE dept = 'D101')
WHERE salary > ALL (SELECT salary FROM emp WHERE dept = 'D101')

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.