Search⌘ K
Home
Courses
Database Design Fundamentals for Software Engineers

The WHERE Clause

Explore how to apply the SQL WHERE clause to filter and retrieve specific records from database tables. Understand the syntax and use of comparison and logical operators to set conditions in your queries.

We'll cover the following...

The WHERE clause

The SQL WHERE clause is used to specify a condition while fetching the data from a single table. If the given condition is satisfied, then those specific records are returned from the table.

Syntax

The basic syntax of the SELECT statement with the WHERE clause is as shown below:

SELECT column1,
...