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:


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:

1JapanAsiaEastern Asia377829Tokyo126714000
3MexicoNorth AmericaCentral America1958201Mexico City98881000
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 5. Chapter 3
toggle bottom row