Relational/Logical

Relational (Comparison) Operators

Compare two values: =, != or <>, >, <, >=, <=.

Logical Operators

Combine multiple conditions: AND (all conditions must be true), OR (at least one must be true), and NOT (negates a condition).

SELECT * FROM employees
WHERE department = 'QA' AND salary > 50000;

Why This Matters

Precise use of relational and logical operators lets testers build very specific verification queries, such as isolating exactly the records that should have been affected by a particular application action.