By adding one or more conditions to my WHERE clause, I can get very specific as to which records I want my query to retrieve. Each condition functions like a true-false statement: If the query examines a record in which the conditional statement is true, the record is returned as output. If the statement is false, the query ignores the record and moves on.
SQL uses two types of operators to build conditional statements, relational operators and logical operators.