The COUNT() Function | Aggregate Functions
Introduction to SQL

# The COUNT() Function

`COUNT()` is a function used for counting. This function enables us to count the number of rows in a table or the number of rows that meet specific criteria. To illustrate, let's start with an example:

To count the total number of rows in the table, we can use the following syntax:

Write an SQL query to retrieve the number of rows from the `country` table where the continent is 'Asia' with a population of over 1000000.

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Section 5. Chapter 3

Course Content

Introduction to SQL

# The COUNT() Function

`COUNT()` is a function used for counting. This function enables us to count the number of rows in a table or the number of rows that meet specific criteria. To illustrate, let's start with an example:

To count the total number of rows in the table, we can use the following syntax:

Write an SQL query to retrieve the number of rows from the `country` table where the continent is 'Asia' with a population of over 1000000.
Here's a short example of the `country` table: