How to Retrieve Filtered Data Using SQL WHERE Clause

Learn how to use Structured Query Language (SQL) to select rows from a table using a filter that matches a certain condition.

You are introduced to the WHERE clause to narrow down the result rows in a query. You can specify the column name, a comparison operator, and the desired value.

You also learn that you can narrow down even more with more conditions using the AND keyword. Later you are also briefly exposed to its counterpart OR keyword.