Learn SQL
COUNT operator
14.1
Lesson

Count all students

Find the total number of students.

We can use COUNT to solve this problem.

Here we are using * to indicate that we want to count all students.

COUNT is the first of aggregate functions we will see in this course. An aggregate function is used to perform some calculations on data. Count, average, sum, maximum and minimum are examples of aggregate function.