Learn The WHERE Clause Operators | Filtering Data

/

Introduction to SQL (60/40)

SQL supports a lot of conditional statements.

Less Than

Let's look at the examples:
This example lists all countries that have a population of less than 2424200:


              123
            
SELECT name, population
FROM country
WHERE population < 2424200;

Less Than or Equal to

The following example retrieves all countries with a population less than or equal to 2424200:


              123
            
SELECT name, population
FROM country
WHERE population <= 2424200;

Not Equal

The following example retrieves all non-Asian countries:


              123
            
SELECT name, continent
FROM country
WHERE continent<>'Asia';

1. Which query returns the names of countries with a population equal to 2,424,200 using the '=' operator in the WHERE clause?

2. Which SQL query returns all countries that are not in Europe using the '<>' operator?

3. Write a SQL query to select the country name and population for all countries with a population between 5,000,000 and 50,000,000, inclusive. Use the BETWEEN operator.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 3

Ask AI

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

What other SQL conditional operators are there?

Can you explain how to use the BETWEEN operator?

Can you show more examples of using IS NULL in SQL?

Swipe to show menu

SQL supports a lot of conditional statements.

Less Than

Let's look at the examples:
This example lists all countries that have a population of less than 2424200:


              123
            
SELECT name, population
FROM country
WHERE population < 2424200;

Less Than or Equal to

The following example retrieves all countries with a population less than or equal to 2424200:


              123
            
SELECT name, population
FROM country
WHERE population <= 2424200;

Not Equal

The following example retrieves all non-Asian countries:


              123
            
SELECT name, continent
FROM country
WHERE continent<>'Asia';

1. Which query returns the names of countries with a population equal to 2,424,200 using the '=' operator in the WHERE clause?

2. Which SQL query returns all countries that are not in Europe using the '<>' operator?

3. Write a SQL query to select the country name and population for all countries with a population between 5,000,000 and 50,000,000, inclusive. Use the BETWEEN operator.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 3

some-alt