{"id":130387,"date":"2022-04-13T18:00:12","date_gmt":"2022-04-13T22:00:12","guid":{"rendered":"https:\/\/brainstation.io\/?post_type=codex-reference&p=130387"},"modified":"2025-02-04T14:34:16","modified_gmt":"2025-02-04T19:34:16","slug":"where","status":"publish","type":"codex-reference","link":"https:\/\/brainstation.io\/learn\/sql\/where","title":{"rendered":"Where"},"content":{"rendered":"\n
<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>

SQL tutorial<\/p><\/div>

SQL Where<\/h1>

Learn more about SQL, a standard language for interacting with databases and storing, manipulating, and retrieving data from databases.

Go hands-on with SQL in our free interactive SQL tutorial.<\/a><\/p><\/div>

<\/div><\/div><\/div><\/header>\n\n\n\n
\n
\n

The SQL WHERE<\/code> clause is used to alter the behavior of a SELECT<\/code> statement or other SQL commands that are applied to rows of data, in order to either restrict the rows returned by a query or the records affected by other statement types (DELETE<\/code>, UPDATE<\/code>, etc.) The SQL WHERE clause is the simplest clause to understand and without question one of the most frequently used.<\/p>\n\n\n\n

Let\u2019s return to looking at the employees table. In the previous section, we used a SELECT<\/code> statement to return all rows from the table, as below:<\/p>\n\n\n\n

Code Example<\/span>