Contents
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
Example
SELECT column1, column2, ...
FROM table_name
WHERE condition;

Pros Main Features
- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid certificates of completion

Pros Main Features
- Professional service
- Flexible timetables
- A variety of features to choose from
- Professional certificates of completion
- University-level courses
- Multiple Online degree programs

Pros Main Features
- Great user experience
- Offers quality content
- Very transparent with their pricing
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
WHERE Clause Operators
Operator | Description |
---|---|
= | Equal |
<> or != | Not equal |
> | Greater than |
< | Less than |
>= | Equal or greater than |
<= | Equal or Less than |
BETWEEN | Between a certain range |
LIKE | Search for a specific pattern |
IN | To define multiple possible column values |
Demo Database
This is a demo database used for examples of this post:
ID | Name | City | Country |
---|---|---|---|
1 | Tom Kurkutis | New York | USA |
2 | Ana Fernandez | London | UK |
3 | Antonio Indigo | Paris | France |
4 | Aarav Kaelin | Delhi | India |
5 | Andrew Tumota | Miami | USA |
6 | Basma Zlata | Miami | USA |
Examples for Using SQL WHERE
The following example selects all the developers from the country 'France' in the Developers table:
This example shows that numeric fields do not require quotes:
Latest Udacity Coupon Found:
Verified STAFF PICK
75% OFF COURSES
Udacity Black Friday Offer
The best time to save on Udacity courses is now - follow this coupon to access a 75% Udacity Black Friday discount & enjoy learning at a very low cost!
Expiration date: 03/03/2021
3176 People Used
Only 97 Left