How to Filter SQL Tables with WHERE Clauses

The WHERE clause is a filter that passes rows that meet the search condition and rejects rows that don’t meet the condition. By including WHERE clauses in SELECT statements, you can restrict the rows that you place into the resulting table to those that satisfy specific conditions. The following table lists the predicates to use to filter for the information you want: