Introduction

In this tutorial, we want to count the number of values of a specific column. In order to do this, we use the COUNT function.

We have already created the table student with the following data:

Example 1

We want to count the total number of students.

In order to do this, we execute the following SQL statement:

SELECT COUNT(studentid)
FROM student;

The following selection is returned:

Example 2

We want to count the number of female students.

In order to do this, we execute the following SQL statement:

SELECT COUNT(studentid)
FROM student
WHERE gender = 'female';

The following selection is returned:

Conclusion

Congratulations! Now you are one step closer to become an AI Expert. You have seen that it is very easy to count the number of values of a specific column. We can simply use the COUNT function. Try it yourself!

Instagram

Also check out our Instagram page. We appreciate your like or comment. Feel free to share this post with your friends.