SQL supports a lot of conditional statements.



<table>
  <tr>
    <th>Operator  </th>
    <th>Equality </th>

  </tr>
  <tr>
    <td>=</td>
    <td>Equality </td>

  </tr>
  <tr>
    <td>!=</td>
    <td>Inequality</td>

  </tr>
<tr>
    <td><</td>
    <td>Less than </td>

  </tr>
<tr>
    <td><=</td>
    <td> Less than or equal to </td>

  </tr>
<tr>
    <td>!< </td>
    <td> Not less than </td>

  </tr><tr>
    <td>></td>
    <td> Greater than </td>

  </tr><tr>
    <td>>=</td>
    <td>Greater than or equal to </td>

  </tr>
  </tr><tr>
    <td>!></td>
    <td>Not greater than </td>

  </tr>
 </tr>
  </tr><tr>
    <td>BETWEEN </td>
    <td>Between two specified values </td>

  </tr>
 </tr>
  </tr><tr>
    <td>IS NULL </td>
    <td>Is a NULL value</td>

  </tr>
</table>

Let’s look at the other examples.
This example lists all countries that have a population of less than 2424200

SELECT name, population
FROM country
WHERE population < 2424200;


The following example retrieves all countries with a population of 2424200 or less.

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

The following example retrieves all non-Asian countries.


SELECT name, continent
FROM country
WHERE continent!='Asia';


In this section, we will learn how to use the SQL SELECT statement to get a single table column, multiple table columns, and all table columns. We will also find out how to return unique values.

In this section, we will learn how to sort retrieved data using the ORDER BY clause. This clause, which must be the last in the SELECT statement, can be used to sort data on one or more columns as needed.\n

In this section, we will learn how to filter returned data using the SELECT statement’s WHERE clause. We will learn how to test for equality, inequality, more and less significant than value ranges, and NULL values.

In this section, we will learn how to combine WHERE clauses with the AND and OR operators. We will also find out how the NOT operator works.\n\n\n

In this section, we will learn what the SQL aggregate functions are and how to use them to summarize table data.