Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
The COUNT() Function | Aggregate Functions
Introduction to SQL

The COUNT() FunctionThe 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:

Task

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:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 5. Chapter 3
toggle bottom row
course content

Course Content

Introduction to SQL

The COUNT() FunctionThe 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:

Task

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:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 5. Chapter 3
toggle bottom row
some-alt