To select rows for which a conditional statement is untrue, you can use the logical operator NOT before any conditional statement in SQL. You can see from the example above that results for which year_rank equals 2 or 3 are excluded. LIKE is frequently used with NOT.

NOT is a logical operator in SQL that can be used before any conditional statement to select rows where the condition is false. In the preceding example, you can see that results with year_ranks of 2 or 3 are not included. NOT is frequently used in conjunction with LIKE.