SQL Statements and Extensions for the Salesforce Driver : SQL Expressions : Operators : Logical Operators

Logical Operators
A logical operator combines the results of two component conditions to produce a single result or to invert the result of a single condition. The following table lists the supported logical operators.
Example
In the Where clause of the following Select statement, the AND logical operator is used to ensure that managers earning more than $1000 a month are returned in the result:
SELECT * FROM emp WHERE jobtitle = manager AND sal > 1000

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