SQL WHERE – the Filtering Clause and Its Operators

SQL WHERE: Main Tips

• The WHERE clause is applied to sort just those records that correspond the condition.
• It is applied in SELECT, UPDATE, DELETE statements.

SQL WHERE Syntax

SELECT column1, column2, ...
FROM table_name
WHERE condition;

Theory is great, but we recommend digging deeper!

An Interactive SQL Tutorial for Beginners: Introduction to SQL

BitDegree Foundation VSI ©

4.5 (139)

WHERE Clause Operators

Demo Database

This is a demo database used for examples of this post:

Examples for Using SQL WHERE

The following example selects all the developers from the country 'France' in the Developers table:

SELECT * FROM Developers
WHERE Country='France';

This example shows that numeric fields do not require quotes:

SELECT * FROM Developers
WHERE ID=1;